Search code examples
ms-accessenterprise-libraryms-access-2007daabautonumber

Get Autonumber from newly inserted record in Access 2007 using Enterprise Library 4.1

It's been ages since I last used Access as a back end but I'm being forced to. I'm using Enterprise Library 4.1, the Data Access Application Block.. with .NET 3.5 and I wanted to know the best way (code sample if possible) to write an insert query that will automatically give me the newly inserted auto-number back..or if it's not possible to do it in one step, how do you recommend doing it?

thanks for your help.

Solution

  • After further research, this just cannot be done in Access in a single step, which is what I was looking for. I will provide links to the pages where I found confirmation about the limitation when i get come.