recordset not updateable

[Lady B]

Okay, I migrated a '97 database into 2007...LONG harrowing process!!!


But...I did it and finally got the database stable and working consistently..

That is, until today. And this has me stumped. I now have an error showing that "this recordset cannot be updated" and the THIS is what has me..this error is ONLY showing on ONE record in the entire database, that I'm able to determine. ALL of the other records let me update, delete, add...except this particular one...

Any ideas?!?!?

[apr pillai]

Probably the table/record may be corrupted! Check the records, after the error record, are showing up correctly or not. Try to edit a record after the error record and check whether it accept changes or not.

If the record in error displays it's data then copy the field contents one by one into a text file.

Note down the total number of records in the Table. Create a Make-Table Query with the table, exclude the record in error with some criteria settings, and create an output table. Check the number of records in the output table after creation and check whether the make-table query transfered all the records except the one in error.

Key-in the data you have copied into a new record in the output table.

Export the table in error, if possible, into a new blank database for safe keep and then delete it from the current database. Rename the output table to its original name.

[Lady B]

apr pillai:

I went in to check on it and do as you suggested...
Not even an hour before I had posted my original thread, I HAD been able to add, update or delete records from this particular table using this exact subform...this morning the ONE record was the only one I was having problems with...I could pull up others and update or change them or even add new...
To make it a little clearer: I am using a form that uses 4 different subforms in it for data entry. The main form uses a main table, the subforms use the record key from the main table to populate -if any data - and yes they do use queries to do it and they all have keys. All 4 of these subforms are exactly the same with the difference being the queries, naturally.
Now, all 3 of the other forms are still working just fine. Updateable, deleteable, insertable...(new words? lol)
But, suddenly, with no changes anywhere, this one form now will not let me make any changes to the recordset...
I know that ACCESS has some major quirks with updating using queries, but these are simple, keyed, and I'm using a subform, not the query directly. The forms are set to Dynaset, as well as the main form. I've made sure that enabled is checked, that locked is no on the main form, and that all of the "allow"'s are yes and that record locks is no...
See, this is what gets me..I've been using this and it working for months now. Even this particular subform. Just last month, I used the main form and the subform in question to add records. I just don't understand HOW or WHY this could just POP up suddenly. Nor do I understand just HOW I'm going to fix it!
I have copied the data, deleted the table, created a new one, added the data, and refreshed everything. Exact same problem.
Oh, and so you know, I have split it. The backend is not accessible by the users. And it compacts on close.

update: I have a copy of the entire db from about a month ago...everything in it works fine. I imported the offending table into a test copy of the backup and I was able to edit the very same record that I originally had problems with...
so, I decided to try to import the "working" form, subforms, and queries in and try that out....bomb. ? Now I'm really stumped...