Interesting, because at my last job I used it successfully with Access '97 and ODBC...I'm really quite sure of it. ------ > @@IDENTITY works in Access. >From my research about @@IDENTITY the last night, it *only* works in Access 2000 using Jet 4.0. http://www.aspwatch.com/c/200043/d1AED4F05B84711D4AF0200A0C9E95208.asp (very bottom) Thanks for an enlightening thread all... Cory --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !