Access (ODBC)

Installing the connector

To check to see if the connectors for Access are already installed on your system

1. Open Microsoft Word with AutoTag installed.
2. Open the 'Data Sources' windows.
3. Click 'Add'.
4. For the vendor, choose 'Access (ODBC)'.
5. Click on the downward arrow next to 'Provider'.

If you are missing the 'Microsoft Access Driver (*.mdb, *.accdb)' option, then you will want to install the 'Microsoft Access Database Engine'.

There are two different installers, depending on the version of Office you are using.

• If you have Office 2000 through Office 2007 or Office 2010 x86:
  • AccessDatabaseEngine.exe
• If you have Office 2010 x64:
  • AccessDatabaseEngine_X64.exe

Both can be found at downloaded from Microsoft here.

If the above link does not function, a copy of the installers can also be found here.

Connecting to your Access database

1. Open Microsoft Word with AutoTag installed.
2. Open the 'Data Sources' windows.
3. Click 'Add'.
4. For the vendor, choose 'Access (ODBC)'.
5. Click on the downward arrow next to 'Provider'.
6. Select the 'Microsoft Access Driver (*.mdb, *.accdb)' option.
7. For server, click the 'Browse' button and select your Access file.
8. Click the 'Test' button to insure you can connect.
9. Click 'OK'.

Installing the connector

There are two different installers, depending on the bitness of the application using the engine.

• If the application is x86 (32-bit) or you are using RunReport on a 32-bit operating system:
  • AccessDatabaseEngine.exe
• If you have Office 2010 x64the application is x64 (64-bit) or you are using RunReport on a 64-bit operating system:
  • AccessDatabaseEngine_X64.exe

Both can be found at downloaded from Microsoft here.

If the above link does not function, a copy of the installers can also be found here.

Connecting to your Access database

If you are connecting to Access through RunReport, you will need the following in the command:

    -odbc "Driver={microsoft access driver (*.mdb, *.accdb)};Dbq=C:\dataFiles\MyAccessData.accdb"

(Note: if your datasource has a name you set in AutoTag, you will want to replace '-odbc' with '-odbc:myDataSourceName').