2.20 Microsoft Access Generic ODBC

Generic ODBC  - Microsoft Access

Aqua Data Studio (ADS) supports connecting to Microsoft Access Databases via Generic ODBC. The Mac operating system does not allow Aqua Data Studio to connect to Microsoft Access Databases with Generic ODBC.

You can get more information about Microsoft ODBC connections here

Vendor: Microsoft

Microsoft Access tutorial for Aqua Data Studio to Connect to Microsoft Access Databases

For Microsoft Access, the entire database is stored as a single file on a host machine either as a .mdb file or .accdb file.

Add the ODBC data source	Create Server Group	Register a Microsoft Access Database	Enter Properties

Generic ODBC Properties MS Access	Microsoft Access Schema	Query in Microsoft Access

 To connect to a Microsoft Access Database using Aqua Data Studio Generic ODBC:

• Make sure you have installed Microsoft Access and have the ODBC driver available.
• Create an ODBC datasource in the Windows->Control Panel->Administrative Tools->Data Sources (ODBC) for the Access database.
• Create a new server Group and name it as MS Access ODBC
• Right Click on server group and click on the the Item which displays Register Server
• Provide a new name for the Microsoft Access Database
• In the General tab, pick Generic - ODBC
• In the Location Datasource field, browse to locate the ODBC datasource for Microsoft Access you created.

The Microsoft Access Database server is registered successfully in Aqua Data Studio. You can now connect to the newly registered Server and perform Data Manipulations