Getting Last Primary Key from SQL Server (1 Viewer)

Thales750

Formerly Jsanders
Local time
Today, 11:12
Joined
Dec 20, 2007
Messages
2,062
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, 11:12
Joined
Dec 20, 2007
Messages
2,062
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