Microsoft KB Archive/115394

{|
 * width="100%"|

Error Opening Access Database After Using It in Query

 * }

-

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 ' ' on machine ' '.

You can't open this database exclusively.

Microsoft Access versions 1.x
Couldn't open file ' '

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.

WORKAROUND
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 In Microsoft Access, clear the Exclusive check box in the Open Database dialog box when you open the database.  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.

Additional query words: 5.00 err msg

Keywords : xlquery xlwin

Version : WINDOWS:1.0,1.1,2.0

Platform : WINDOWS

Issue type :

Technology :