Exclusive Database mode

[GUIgirl]

I get the following message when trying to create a query using to two tables
that have a one to many relationship.

The wizard is unable to open your query in datasheet view, possible because
another user has a source table open in exclusive mode. Your query will be
opened in design view.

The database is not on a shared drive. I do not have the database opened
someplace else and I check all of the tables to make sure all had the shared
table button chosen.

Is there something else I am not doing? Thanks

 

[MGFoster]

I get the following message when trying to create a query using to two tables
that have a one to many relationship.

The wizard is unable to open your query in datasheet view, possible because
another user has a source table open in exclusive mode. Your query will be
opened in design view.

The database is not on a shared drive. I do not have the database opened
someplace else and I check all of the tables to make sure all had the shared
table button chosen.

Is there something else I am not doing? Thanks

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

This error occurs when the table being queried is open in Design View.
Make sure the table you are querying is in Datasheet view or closed.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSezw4IechKqOuFEgEQIUkgCgzP9ttPdCKm2yZXe5zzQiHFNb7xsAoIq4
vcsoWRsX1xPzXKHy7AJ5GrAq
=dCcs
-----END PGP SIGNATURE-----