In a Excel VBA project I would like to create a transaction in a Access 2010 database. After the creation I would like to retrieve the ID of the just created transaction. How can I do this? Do I need to assign each transaction a unique id before it is created a retrieve the transaction by this unique id?