Non updateable recordset

[Guest]

What causes a form recordset to be not updateable?

I've created a form that is based on 4 tables that worked very well until
recently. The form is not associated with any queries and has two subforms
that collect items and a button to add the sum of the items and update field
totals as well as some other calculations.

I now get the message "Recordset is not updateable".
The form worked fine and was able to be updated and additions created at the
time of the last update onto the server. I'm assuming that this problem may
have started when a separate table, not associated with this form,
encountered a corrput record and gave the message "Record is Deleted". I
fixed the issue with the Compress and Repair tool used on the BE.

Any ideas would be greatly appreciated as I dont know where to start.

 

[Douglas J. Steele]

See whether http://support.microsoft.com/?kbid=328828 helps

 

[Dirk Goldgar]

What causes a form recordset to be not updateable?

I've created a form that is based on 4 tables that worked very well
until recently. The form is not associated with any queries and has
two subforms that collect items and a button to add the sum of the
items and update field totals as well as some other calculations.

I now get the message "Recordset is not updateable".
The form worked fine and was able to be updated and additions created
at the time of the last update onto the server. I'm assuming that
this problem may have started when a separate table, not associated
with this form, encountered a corrput record and gave the message
"Record is Deleted". I fixed the issue with the Compress and Repair
tool used on the BE.

Any ideas would be greatly appreciated as I dont know where to start.

If you really didn't change anything in the tables or queries related to
this form, and haven't changed the form itself in anyway, then ... if
you think the problem may have started when you had a repaired
corruption in the back-end, then *maybe* relinking all the tables in the
front-end will fix the problem. It's worth a try, anyway.

Have you verified that all the table are independently updatable?