Error Opening Access Database After Using It in Query

ID: Q115394

1.00 WINDOWS kbinterop

The information in this article applies to:

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
```

Note that this setting affects all data sources, not just Microsoft Access data sources.

KBCategory: kbinterop KBSubcategory: xlquery xlwin

Additional reference words: 1.00 1.10 2.00 5.00 err msg

Keywords          : xlquery xlwin 
Version           : 1.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996