Connect to an Existing MS Access Database
The procedure given below is suitable if you want to connect to a Microsoft Access database that is not password-protected. If the database is password-protected, use the method given in the Connection Example for Microsoft Access (ADO).
1.Run the database connection wizard (see Starting the Database Connection Wizard).
2.Select Microsoft Access (ADO), and then click Next.
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.
You can also open a Microsoft Access database directly from Windows Explorer as follows:
1.Right-click an existing database file in Windows Explorer and select Open With from the context menu.
2.Choose DatabaseSpy from the list of suggestions. If DatabaseSpy is not listed, select Choose another app and browse for the DatabaseSpy executable in the application directory.
3.If the Database Connection Wizard appears, click Close to disregard it.
You can also drag and drop the database file into DatabaseSpy if the latter is already open.
Notes about DatabaseSpy
•You can optionally configure DatabaseSpy from Tools | Options so as not to show the Database Connection Wizard whenever the application starts. To do this, clear the check box Show create a database connection dialog in the General group of settings.
•If DatabaseSpy is open and a data source to the same database file already exists, the data source will be reused; no duplicate data source will be created.