edit query

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

I have a strange problem now, some queries which I open cannot be edited and
other can?

What can cause this problem?

herman
 
1. Queries that are based on 2 or more Tables may not be updateable
depending on the joins you use.

2. Totals Queries are not updateable.

3. If the RecordsetType of the Query is "Snapshot", the Query is not
updateable.

4. There are other reasons for a Query to be non-updateable.
 
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

edit data in query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Unable to edit form data 1
Cascading Combo 3
Straight forward button. 2
combo box auto update multi fields 2
Add field to continuous form 5
Issues Displaying results in Combo Box in Access 2003 2

Back
Top