Recordset cannot be updated

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

Guest

I am getting this message and of course cannot add any new info / records to
the DB. Why would this be?

Note: the main form is based off of a query. I also just added a new table.
 
See the help file about Updating Underlying tables.

But, sometimes, when you add a table to a query, thus a link, it makes the
recordset none-updateable. For example, you would not want to update the
Foreign Key of the child table.
 
off the cuff - since you mention a Form - check its property to see of the
Record Locks is on......
 
Go to Form Property->Data->RecordsetType
Select "Dynaset (Inconsistent Updates)" as Recordset Type
Type Keyworks "RecordsetType" in Microsoft Access Help for more information.
 
Back
Top