Locked Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

a query has suddenly become locked and cannot be editted.

Tried closing and reopening the program/file but the problem is still there.

Any solutions?

Jonty
 
Copy the SQL to a new query and see what happen.

Did you make any changes to the tables that the query is based on?
 
Hi

Thx for the reply.

Tried a new SQL - same problem

No changes made to the tables.

Jonty
 
That usually hapen we you have two tables joined together and not by the key
field.

Can you post the SQL?
Is the query based on another query? if so, check the second query.
 
Still not soerted despite your offerings.

Ofer said:
That usually hapen we you have two tables joined together and not by the key
field.

Can you post the SQL?
Is the query based on another query? if so, check the second query.
Click to expand...
 
Jonty said:
a query has suddenly become locked and cannot be editted.

Tried closing and reopening the program/file but the problem is still there.

Any solutions?

Jonty
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locked Query 1
Can't delete file 3
Subform/Subreport:Call Listing Subform 6
Access Front - SQL Back - File Locking 6
Form Suddenly Became Non-Editable? 1
Record-Locking remains open after closing 0
Sharing CSV files with Access 9
see Deleted # after run Delete and append query 1

Back
Top