I would like the know the identity value of the record that i am about to insert. Is the only way to get this to perform a query before hand? or is there a command that can do this? Thanks.
for MS SQL Server<BR>http://www.aspfaqs.com/webtech/tips/t122600-1.shtml<BR><BR>For Access<BR>http://www.aspfaqs.com/ASPScripts/PrintFAQ.asp?FAQID=79<BR>