RE: FN-FORUM: asp/sql - the correct way to get the ID of the record you just added?

date posted 9th January 2007 17:46


> MS Access (not going to start a flame war by describing it) has no direct
way
> afaik, so then yes you are stuck with highest id or making it unique on
other
> fields. Don't use accesss much so may be out of date there.

Access also supports "SELECT @@identity" (assuming Jet OLE DB v4+):
http://support.microsoft.com/default.aspx?scid=kb%3b%5bLN%5d%3bQ233299

Ben

--
Ben Johnson, MD
Neogic Web Solutions

w | http://www.neogic.com
t | +44 (0)1242 808 262
e | [EMAIL REMOVED]