Retrieve ID after inserting into Access database

R

refer_to_website

I am using VB.NET to insert a record into an Access database. The
database table uses an AutoNumber for its primary key. How can I
determine what value Access assigned to the primary key?

All the research I've done says to use @@IDENTITY but that appears to
only work for SQL Server? How can I do this in Access?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,787
Messages
2,569,627
Members
45,329
Latest member
InezZ76898

Latest Threads

Top