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

Forum statistics

Threads
473,766
Messages
2,569,569
Members
45,042
Latest member
icassiem

Latest Threads

Top