Getting Last Primary Key from SQL Server (1 Viewer)

Thales750

Formerly Jsanders
Local time
Today, 10:00
Joined
Dec 20, 2007
Messages
2,061
Has anyone experienced unreliable results from using this line of code to return the latest Primary Key?

Code:
CurrentDb.OpenRecordset("SELECT @@IDENTITY AS LastID")!LastID


Thanks,
 
Last edited:

Thales750

Formerly Jsanders
Local time
Today, 10:00
Joined
Dec 20, 2007
Messages
2,061
That is exactly what it is.
I'm leaving a message on your tread concerning this issue.
 

Users who are viewing this thread

Top Bottom