I can't update my form

[Guest]

I created a form to input data into three tables in Access 2000. I am able to
add new records to all three of those tables. However, I cannot edit, delete,
or add any records in the form itself. There is a message whenever I try at
the bottom of the window saying "This Recordset is not updateable". I have
checked the properties of the form about ten times now, Allow Edits is Yes,
Allow Deletions is Yes, Allow Additions is Yes. Record Locks is on No Locks.
Recordset Type is Dynaset, not that I know what that means, but it seems
relevant. Can somebody help me? I am stumped and not very experienced with
Access.

 

[Ken Snell [MVP]]

Queries must be updatable if they are to be used for entering data or for
editing data. It sounds as if the query that you're using as the form's
Record Source is not updatable.

There are many possible reasons for this ....

See these MS Knowledge Base articles for more info about updatable queries:

ACC2000: Cannot Edit or Update Record on a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;209571&Product=acc

ACC2000: Status Bar Displays "Recordset Not Updateable" Message When You Try
to Update a Linked Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;304179&Product=acc

INFO: Troubleshooting Errors That May Occur When You Update Data in Queries
and in Forms
http://support.microsoft.com/default.aspx?scid=kb;en-us;328828&Product=acc

ACC: Update Query Based on Totals Query Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;116142&Product=acc

If you give us more info about the query that you're trying to use, we might
be able to give more specific information.