Insert and retrieve ID

[Newsgroup_User]

Is there a free extension to allow an insert and get ID of the record
inserted?
Im using DWMX and Access 2000

Thanks
Andy

[Newsgroup_User]

> Is there a free extension to allow an insert and get ID of the record
> inserted?
> Im using DWMX and Access 2000

I have no idea about a free extension that works with Access, but in SQL,
you'd use the @@identity syntax:

http://www.4guysfromrolla.com/webtech/100598-1.shtml

-Darrel