[thelist] SQL: insert into mutiple tables help

Tab Alleman talleman at autobex.com
Wed Apr 11 12:43:45 CDT 2001

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

Thanks for an enlightening thread all...


For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list