Error Opening Access Database After Using It in Query

• Microsoft Query for Windows, version 1.0
• Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

When you create a query or open an existing query in Microsoft Query, using a Microsoft Access data source, and you then open the database in Microsoft Access that you used in the query, one of the following error messages will appear (even if the query is closed, if Microsoft Query is still running):

   Microsoft Access version 2.0
   ----------------------------

   The database is opened by user '<username>' on machine '<machinename>'.
   You can't open this database exclusively.

   Microsoft Access versions 1.x
   -----------------------------

   Couldn't open file '<path><filename>'

CAUSE

You receive this error message if you open the database exclusively in Microsoft Access. Even though the query that used the Microsoft Access database is closed, a connection to the database still exists in Microsoft Query.

WORKAROUNDS

To avoid receiving this error message, when you open a database that has been used in query in Microsoft Query, do one of the following:

• Close Microsoft Query

  -or-

• In Microsoft Access, clear the Exclusive check box in the Open Database dialog box when you open the database.

  -or-

• Edit the MSQUERY.INI file, located in your Microsoft Windows directory, by modifying the AutoDisconnect option in the [Microsoft Query] section to the following:

        AutoDisconnect=1