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.
3.Select Use an existing MS Access database.
4.Browse for the database file, or enter the path to it (either relative or absolute).