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.
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.