1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Inserting database records into Microsoft Access 2010

Discussion in 'C#' started by sfultz, Sep 6, 2012.

  1. sfultz

    sfultz New Member

    Sep 6, 2012
    Likes Received:
    Trophy Points:

    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

Share This Page