How to Get Just Added Primary Key / Autonumber Value

  • Thread starter Thread starter Mike Thomas
  • Start date Start date
M

Mike Thomas

In Access 2000, in the statement below, is there a way to retrieve the value
of the Autonumber/ Primary Key field which Access has just inserted
automatically into the table's new row?

strSQL = "INSERT INTO [SomeTable] (Field2, Field3) " & _
" VALUES ( Val1, Val2 )"

db.Execute (strSQL)


Many thanks,
Mike Thomas
 
Hi,


If you use

CurrentProject.Connection.Execute strSQL


then, you can check

var = CurrentProject.Connection.Execute("SELECT @@IDENTITY")



@@IDENTITY is maintained by connection (so, by user), so you must use
the same reference than you use to execute the SQL statement.



Hoping it may help,
Vanderghast, Access MVP
 

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

Similar Threads

Can't seem to retrieve primary key number of newly created record in VB 1
Foreign Key problem 2
Primary Key value from record added programmatically 14
When does foreign key update? 6
Get PK or autonumber of Newly appended Record 6
Primary Key Autonumber 4
Retrieve Autonumber Added 2
Primary Key Violation Error Message 3

Back
Top