My Form is Locking Me Out

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

Guest

I have a form that is connected to a query. For some reason when I added
another table to the query and connected the two tables, the query and form
that is connected to it lock up so I cannot add or delete any information.
When I go back into the query and delete the table, the query and form work
except that now I cannot use the info from the other table that I had to
delete. Any thoughts?
 
Mo,

The inclusion of the additional table into your query is apparently
rendering the query non-updateable. There are a number of conditions
that define whether a query is updateable or not - there is some good
information in Access Help about this. If you need more explicit help
with this, maybe you could post back with the SQL of the query.
 
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

Record-Locking remains open after closing 0
Access Lock Violations 0
"Read Only" Query 0
Parameter Value error in a Subform 0
On db Exit 4
Form field list 2
Form based on crosstab query 1
HOWTO query by passing a parameter from Infopath 20007 to a MicrosoftAccess 2007 database? 1

Back
Top