Dynamic AI - Microsoft Access 2007

Support documents related to Microsoft SQL Server, Microsoft SQL Server Express, Microsoft Access and Microsoft Excel Databases

Dynamic AI - Microsoft Access 2007

Postby Carsten Sørensen » Sun Jan 18, 2009 12:41 pm

Connecting Dynamic AI to Microsoft Access 2007

Connecting to Microsoft Access 2007 is different than previous Access versions (please see separate topic for MS Access 97-2003).

Use the database connection screen in Dynamic AI and select Access Database 2007 from the Type list.

Use browse to find and specify the database file OR type the full path to the file.

Browse will only be available when you are using Dynamic AI on the same PC as where you have installed Dynamic AI. If you setup connection on a Dynamic AI Server or Enterprise edition - be aware that you should specify the path as seen from the server.

Be aware that Access is a file-based database and that the windows user used by the Dynamic AI installation has sufficient (read/write) access rights to the file.


If your database is protected with a database password - please specify the password:


Test the connection by pressing the ‘Test Connection’ button.

Click SAVE to save the connection. Now you should see the database in the database Explore and be able to browse and use Tables and Views of the database.


In most cases the needed database drivers are already installed. However if you experience problems with the connection then you should check whether the ODBC/OLEDB driver for Access is installed. This can be checked in the Control Panel -> Administrative Tools -> ODBC Driver.

Under the tab System DSN press ‘Add’. Check is if the MS Access ODBC driver is installed.


If there is no ODBC driver installed you can download the MDAC client from:
http://www.microsoft.com/downloads/deta ... laylang=en

This driver contains core Data Access components such as Microsoft SQL Server, OLE DB provider and ODBC driver.

Sample data

The DEMO optionally installed with Dynamic AI includes a sample Microsoft Access DEMO database (V6_Demo.mdb - 97-2003 format) connected to Dynamic AI and used for reports etc.

Interested in a free Dynamic AI Personal edition? Download the latest version from: http://www.dynamicai.com/download.htm

Would you like a Dynamic AI Server edition trial version please contact: info@dataaccess.nl

If you have any questions, you are always welcome to contact one of our partners (more information available at: www.dynamicai.eu , www.dynamicai.com) in your country, or e-mail your questions directly to: info@dataaccess.nl

Copyright © 1998-2009 CINTAC A/S and/or its suppliers. All rights reserved. Dynamic AI ™, Dynamic Financials ® and CINTAC Dynamic are registered trademarks or trademarks of CINTAC A/S.
Microsoft, Windows and Access are registered trademarks of Microsoft Corporation. All other products may be trademarks or registered trademarks of their respective companies.
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Return to Microsoft SQL Server / Express / Access / Excel