Skip to main content
Windward

Access (ODBC)

autotag-wiki-logo.pngThis Data Source is not supported anymore!

Overview

This article covers how to connect to Access data sources.

 

Starting with our version 14 release Windward will no longer support Microsoft Access files as a datasource format.   The connector and code will remain in the product however we will no longer answer questions regarding Microsoft Access datasource or add new features.  Windward recommends upgrading your Microsoft Access database to a Microsoft SQL Server.  

 

Details on this process can be found in this blog post:

From Excel to SQL: How to Get Your Data in Order (So You Can Use It for Years to Come)

AutoTag

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

Connector.png

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

.NET Engine

Install 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 data source has a name you set in AutoTag, you will want to replace '-odbc' with '-odbc:myDataSourceName').

Java Engine

The Windward Java Engine currently do not support Access databases as a data source.

Video

  • Was this article helpful?