Database Compare Suite™

Connecting to a Microsoft Access database

Use the following procedure to connect to your Microsoft Access database.

  1. Click the New icon in the Project panel at the top left corner of the window

  2. Select Microsoft Access in the Platform drop-down list at the top of the dialog box.

    • If the Microsoft Access Database Engine 2010 Redistributable application is not installed on your PC, you will need to install it. For more information, see Installing the Required Database Drivers.

    • After installing the driver, restart the Database Compare Suite application and get back to item # 1.

  3. Select the Standard option in the Mode drop-down list if you would like to connect to Microsoft Access database in the standard mode.

    • Specify the path to the database file in the DataSource field. You can enter it manually or select it from the drop-down list (if it has been already used).

    • Enter the Password to complete the information about Microsoft Access database connection.

    • Press the Test button to verify that you can successfully connect to your Microsoft Access database.

  4. Select the ConnectionString option in the Mode drop-down list if you would like to connect to Microsoft Access database, using the connection string.

    • Enter the Connection string manually or select from the drop-down list (if it has been already used).

    • Find the connection string template below. Use it as an example to create a connection string that allows to connect to your Microsoft Access database:

      Data Source=C:\Access\access_db.accdb;Database Password=pass
      
    • Press the Test button to verify that you can successfully connect to your Microsoft Access database.


Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].