Altova DatabaseSpy 2025 Professional Edition

Connecting to Microsoft Access (ADO)

Home Prev Top Next

A simple way to connect to a Microsoft Access database is to follow the wizard and browse for the database file, as shown in Connecting to an Existing Microsoft Access Database. An alternative approach is to set up an ADO connection explicitly, as shown in this topic. This approach is useful if your database is password-protected.  

 

It is also possible to connect to Microsoft Access through an ODBC connection, but it has limitations, so it is best to avoid it.

To connect to a password-protected Microsoft Access database:

1.Start the database connection wizard.

2.Click ADO Connections.

3.Click Build.

ExampleAccess03

4.Select the Microsoft Office 15.0 Access Database Engine OLE DB Provider, and then click Next.

ExampleAccess04

5.In the Data Source box, enter the path to the Microsoft Access file in UNC format, for example, \\myserver\\mynetworkshare\Reports\Revenue.accdb, where myserver is the name of the server and mynetworkshare is the name of the network share.

6.On the All tab, double click the Jet OLEDB:Database Password property and enter the database password as property value.

ADOConnectionDialog02
Note:If you are still unable to connect, locate the workgroup information file (System.MDW) applicable to your user profile, and set the value of the Jet OLEDB: System database property to the path of the System.MDW file.

© 2018-2024 Altova GmbH