Access AutoNumber Insert


Author
Message
Crones
Crones
StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)
Group: Forum Members
Posts: 35, Visits: 345
Ok... I'm having a major brainfart here... I could've sworn I saw a posting somewhere here talking about retrieving AutoNumber fields from an Access DB after an insert awhile back....



Anyways, how to I get the new AutoNumber value after adding (and saving) a BO? It keeps returning -1 on me...



Do I have to resort to executing a "SELECT @@IDENTITY" command to retrieve it?
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search