Re^2: Last Insert ID in MS Access

in reply to Re: Last Insert ID in MS Access
in thread Last Insert ID in MS Access

This article suggests that the correct syntax is SELECT @@IDENTITY, and that you should open a second connection to get it. This is presumably problematic with multiple users, so it is as effective (and unreliable) as MAX(ID) would be. I think you could probably lock the table for update and unlock the table after getting the last id.

Comment on Re^2: Last Insert ID in MS Access Select or Download Code

Replies are listed 'Best First'.
Re^3: Last Insert ID in MS Access by mje (Curate) on Jul 19, 2010 at 08:28 UTC
I think you'll find it doesn't work if run in a "second connection". I think you just need to ensure it is run as a new statement in the same connection after any outstanding commit.	[reply]

In Section Seekers of Perl Wisdom