Hello, I am writing a application that reads an access 2010 database file (source) and inserts the records it finds into another Access 2010 database (destination) Both the source database and the destination database have the same exact fields on purpose, although I test for that in my code. Both databases have an ID field that is an AutoNumber. My question is how do I find out the next available AutoNumber value in the destination database so that I don't overwrite any data that already exists in the destination database? Im using C# 2010 and the System.Data.Odbc class to connect to both the source and destination databases. I am using a windows Forms application
