Skip to main content
Inspiring
July 17, 2006
Question

Insert and retrieve ID

  • July 17, 2006
  • 1 reply
  • 253 views
Is there a free extension to allow an insert and get ID of the record
inserted?
Im using DWMX and Access 2000

Thanks
Andy


This topic has been closed for replies.

1 reply

Inspiring
July 17, 2006

> 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