Recordset is not updatable

  • Thread starter Thread starter Tim Leach
  • Start date Start date
T

Tim Leach

Gentleman and ladies,

None of my edit forms will allow you to edit anything. A message comes up
in the right hand side of the lower screen that says, "The dataset is un
updatable"

Any Ideas, I don't know what happened.

Please help
Tim Leach
 
Tim said:
Gentleman and ladies,

None of my edit forms will allow you to edit anything. A message
comes up in the right hand side of the lower screen that says, "The
dataset is un updatable"

Any Ideas, I don't know what happened.

Please help
Tim Leach
Click to expand...

Queries (particularly those with multiple tables in them) often produce
non-editable result sets. If you are using queries as the RecordSource for your
forms have you checked to see if you can edit them directly?
 
Queries (particularly those with multiple tables in them) often produce
non-editable result sets. If you are using queries as the RecordSource for your
forms have you checked to see if you can edit them directly?
Click to expand...

The query is the record source for the form. It does use two tables, and it
won't let me edit in datasheet view either. Any ideas?
 
Tim Leach said:
The query is the record source for the form. It does use two tables, and it
won't let me edit in datasheet view either. Any ideas?
Click to expand...

There is a help topic that you need to read named "When can I edit data in a
query?" or some similar name to that. The crux of it is that the database
engine needs to have zero ambiguity about what table, row, and field a change
would need to be applied to. Anything about the construct of the query that
imposes some ambiguity and the engine will disallow edits as a means to maintain
integrity of the data.

In the case of multi-table queries one can often tweak the design a bit to
achieve an editable ResultSet. Other than a query that does a very simple
lookup though I don't recommend attempting edits with such a query. In some
cases you can end up with a design that is editable, but the edits are not
applied to the expected table which can result in a loss of data.
 
Back
Top