Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Access AutoNumber Query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-14 : 11:58:47
Benjamin writes "I am trying to find a way to get an autoNumber field which is a primary key for a record atomically.

Bascially I have to do an insert into a Access Database using ASP.
The insert will yield a new PrimaryKey for the record I am using, and other inserts could be occuring at the same time.

How do I get the primarykey for the record I just inserted?

Ben"
   

- Advertisement -