CAn't Edit data in Select Query or forms

  • Thread starter Steve Murphy (Kuwait in Army**US)
  • Start date
S

Steve Murphy (Kuwait in Army**US)

I have made a select query drawing information from six different tables all
syncronizing data from the order ID, I have made forms based on the query
results and now I cannot edit the information in the forms or the queries
directly.

Steve

Thank you for any help
 
R

Rick Brandt

Steve said:
I have made a select query drawing information from six different
tables all syncronizing data from the order ID, I have made forms
based on the query results and now I cannot edit the information in
the forms or the queries directly.

Steve

Thank you for any help
Click to expand...

Read the help topic "When can I edit data in a query?"

There are many things that can render the results of a query non-editable and
having it include mutliple tables is one that "can" cause it. It's not an
absolute, but the structure of the query has to be "just right" for a
multi-table query to be editable and the more tables you add the harder it is to
maintain that ability.

Basically as you add more tables, it become increasingly difficult for the
database engine to know which tables to apply the updates to. Once an
"ambiguity threshold" is exceeded the query is made read-only as a means to
avoid data integrity problems.

Access/Jet is just about the most forgiving database in this area. Many engines
will absolutely not allow edits if a query/view has even two tables in it.
 
Top