I Get Recordset Not Updateable Error Message In Access 2003

C

CS440TTLSER

After closing down my Access 2003 database one night I found the following
morning upon opening the data base that one form & a different form subform
were not longer editable. AllowEdits, AllowAdditions, etc are all set to yes
.....

Help!!!

Peter ( New User )
 
A

Allen Browne

If the form is based on a query, open the query directly.
Can you enter data into the query?

If not see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
for a list of things to trace down.

If the query is updatable, but the form is not, check the properties on the
Data tab of the form's properties:
Recordset Type Dynaset
Data Entry No

Also, check the main form's properties. If the main form's AllowEdits is no,
you won't be able to edit in the subform either.
 
S

Sprinks

Is it possible that the form's RecordSource was changed to the name of a
non-updateable query? To check for "updatability", open the form and check
the RecordSource property. If it is a query, open the query itself and
attempt to change data.

Sprinks
 
Top