How to read Geomedia Access .accdb Warehouse

Introduction

The Geomedia Access Warehouse reader normally expects to be provided with the location of an Access MDB file. However, it can also read from the newer ACCDB format through an ODBC link. To set up this link, please follow these steps:

Create ODBC link to ACCDB file

If you do not have Microsoft Office 2010 or newer installed on your computer, you may need to download and install the Microsoft Access Database Engine 2010 Redistributable (https://www.microsoft.com/en-ca/download/details.aspx?id=13255) to get the .accdb ODBC drivers.

Start Control Panel and type ‘odbc’ into the Search Control Panel box:

Click on the Set up data sources (ODBC) link to start the ODBC Administrator:

If you are on 64 bit Windows and are using the 32 bit version of Microsoft Office, or only installed the 32 bit runtime, you will need to start the 32 bit ODBC Administrator instead, which can be found at “C:\Windows\SysWOW64\odbcad32.exe”

Click the Add button to bring up the Create New Data Source dialog:

Select the Microsoft Access Driver (*.mdb, *.accdb), then click the Finish button to bring up the ODBC Microsoft Access Setup dialog:

Enter a data source name, then click the Select button and select the .accdb file you want to read. Click OK to save the connection.

When adding Geomedia Access Warehouse reader in FME, type the data source name you set in the ODBC Administrator into the Dataset box, instead of navigating to the .accdb file:

FME will read the Warehouse through the ODBC connection.