Access 2007 - Return ID of last record inserted
Posted on 2011-02-25
I need a way to return the ID of the last record inserted into a table. I've found a few places out there with commentary on this, but I'm not sure what the best practice is to make this happen.
Are there transactions in access? Should I include the insert and the ID retrieval as part of the same transaction so I can be sure I'm getting the correct ID back?