Please enable JavaScript to view this site.

Altova XMLSpy 2022 Professional Edition

Databases > Connecting to a Data Source > ADO Connection

Connecting to an Existing Microsoft Access Database

Scroll Home Prev Top Next More

This approach is suitable when you want to connect to a Microsoft Access database which is not password-protected. If the database is password-protected, set up the database password as shown in Connecting to Microsoft Access (ADO).

To connect to an existing Microsoft Access database:

1.Run the database connection wizard (see Starting the Database Connection Wizard).

2.Select Microsoft Access (ADO), and then click Next.

access_connect_existing

3.Select Use an existing MS Access database.

4.Browse for the database file, or enter the path to it (either relative or absolute).

5.Click Connect.

© 2015-2021 Altova GmbH