error:characters found after end of sql statement

[myinstincts]

i wrote a command like 'select max(admission_no) from user_details'in ms access.but it is giving the error as 'characters found after end of sql statement'.Can anybody help me with this?

[Vimalsoft Pty Ltd]

Please Give us more info. Where are you using this query ? from your code or this is in the Storeprocedure. Give us more info so that we can help.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/