Set up a data source that uses the Microsoft Access driver

Microsoft Query

Show All

Set up a data source that uses the Microsoft Access driver

  1. If the Create New Data Source dialog box is not displayed, click New on the File menu, click the Databases tab, and then double-click New Data Source. Type a name for the data source in step 1, and select Microsoft Access Driver in step 2.
  2. In step 3, click Connect.
  3. Under Database, click Select, and use the Select Database dialog box to locate your database file.

    If you want Microsoft Query to open the database as read-only, select the Read Only check box.

    If you want Microsoft Query to be the only user of the database when you use this data source, select the Exclusive check box.

  4. Click OK.

    If your database requires you to set additional connection parameters, click Advanced. For information about whether you need to change any of these settings, see the administrator for your database. For information about the advanced settings, click Cancel, and then click Help in the ODBC Microsoft Access Setup dialog box.

  5. If you want Microsoft Query to access the system database, click Database under System database, and then click System Database. In the Select System Database dialog box, locate your system database file, and then click OK.
  6. Click OK, and enter your logon name and password under Authorization. If you don't use a logon name or password to gain access to the database, leave the boxes under Authorization blank.

Note   You can use the ODBC Microsoft Access Setup dialog box to create, repair, and compact Microsoft Access databases. If you are not familiar with these operations, you should perform them only from within Microsoft Access. For more information, see Microsoft Access Help.