Read-only Recordset

[firestorm1983]

I have a fairly large access database that was working fine for a long period of time. Then after a compact and repair was completed, I receive this message after opening an access page "You can't add or delete an existing record because the recordset for this page is read-only." The page that I am trying to use has several fields that link to a table so that users can enter data into the database through just an internet page. All other pages within the database work correctly. I am able to enter data directly into the table, but not from the page. Any ideas as to how the compact and repair could have caused this the issue with the recordset being read-only?

 

[firestorm1983]

I forgot to mention that the version of access being used is 2002 although the database is saved to a 2000 file format

 

[fneily]

Like a deer with no eyes, I have no idea. However, for a DAP to be editable, you must include the tables primary key on the DAP. If the table has no primary key, then the DAP will remain uneditable.
If it was actually editable before, you could quickly and simply recreate it. But try to stay in the same version - microsoft says things are compatible, but I don't know anyone who has grown younger.