Problem creating query

[Guest]

why is it that as soon as you fix one problem another one needs dealing with

OK, the problem i have is that i have a BE/FE configuration database in a
multiuser environment. I have built all the tables and the relationships in
the BE configuration. In the FE configurations i have built the main forms to
input data. It has no come to the point where i have begun to create the
queries to allow reporting and data searching. And this is where i have a
problem. I am trying to create a simply query and i do mean simple (at the
moment i simply want 2 fields from 1 table and 2 fields from another table)
no calculations or anything i just want it to display the data. I have tried
creating this query numerous times and i keep getting the same error.

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

the above is the error i get when i use a wizard to create the query, after
getting this message and going into design view i try to view the results in
datasheet view and get the following error "Type Mismatch in expression"

If i dont use a wizard and create it in design view, when i go to view the
results i get the second error message everytime.

If i create a query from 1 table only the query works without errors, but i
always get errors when i have more than one table in the query.

Also i am the only person with the database open so therefore it is total
impossible for the database to be open by another user in exclusive mode.

Anyone know what the problem might be or how to fix. Your answers will be
very much appreciated.

 

[John Vinson]

why is it that as soon as you fix one problem another one needs dealing with

"There is no problem, however complex, that when looked at in the

OK, the problem i have is that i have a BE/FE configuration database in a
multiuser environment. I have built all the tables and the relationships in
the BE configuration. In the FE configurations i have built the main forms to
input data. It has no come to the point where i have begun to create the
queries to allow reporting and data searching. And this is where i have a
problem. I am trying to create a simply query and i do mean simple (at the
moment i simply want 2 fields from 1 table and 2 fields from another table)
no calculations or anything i just want it to display the data. I have tried
creating this query numerous times and i keep getting the same error.

My guess is that you either have the table open in datasheet view,
exclusively, at the time you're trying to create the query; or that
you have a leftover .LDB locking file from some previous abnormal
termination of Access. Check your file folder containing the .mdb file
(while you're not using Access!); if there is a .ldb file with the
same filename as your .mdb file, delete it.

And check how you're opening Access; be sure you're opening it shared,
not exclusive.

John W. Vinson[MVP]

 

[Guest]

My guess is that you either have the table open in datasheet view,
exclusively, at the time you're trying to create the query; or that
you have a leftover .LDB locking file from some previous abnormal
termination of Access. Check your file folder containing the .mdb file
(while you're not using Access!); if there is a .ldb file with the
same filename as your .mdb file, delete it.

And check how you're opening Access; be sure you're opening it shared,
not exclusive.

Have done all of this and still get the problem...

 

[Guest]

For future reference in case anyone else comes across this problem, i have
found the solution. Check the datatype of your foreign key in the table, i
checked mine and found that it was set to a text data format instead of a
number long integer, as soon as i changed it i no longer got the errors and
the queries can now be built

My guess is that you either have the table open in datasheet view,
exclusively, at the time you're trying to create the query; or that
you have a leftover .LDB locking file from some previous abnormal
termination of Access. Check your file folder containing the .mdb file
(while you're not using Access!); if there is a .ldb file with the
same filename as your .mdb file, delete it.

And check how you're opening Access; be sure you're opening it shared,
not exclusive.

Have done all of this and still get the problem...

"There is no problem, however complex, that when looked at in the


My guess is that you either have the table open in datasheet view,
exclusively, at the time you're trying to create the query; or that
you have a leftover .LDB locking file from some previous abnormal
termination of Access. Check your file folder containing the .mdb file
(while you're not using Access!); if there is a .ldb file with the
same filename as your .mdb file, delete it.

And check how you're opening Access; be sure you're opening it shared,
not exclusive.

John W. Vinson[MVP]