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

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.