I have a db that was created in Access 2003. It has been split into a front-end and a back-end. It has been written to (~1200 rec) and all of a sudden last Friday strange things began to happen - Database took up to 6min. to open, certain reports stopped working (I kept getting Runt-Time error '3167'. Record is deleted.), some drop downs on forms stopped working, etc. With dropdowns that were "busted" (show no options when clicked), I took the rowsource from them, opened a new query, and pasted the SQL from the rowsource in it and ran it - this new query produced the correct data for the options of the drop down, but it would not work in the dropdown.
So at that point, I decided to run Tools>Database Utilities>Compact and Repair Database... on the front end. Nothing happened. Then I ran it on the back end, opened the front end and everything (Forms, dropdowns, queries etc) worked correctly, except that the first record in the main form contained a bunch of "#" in all fields.
That seemed funny to me so I opened the back-end and looked at the list of tables and noticed a MSysCompactError Table appeared (attached). Also, the tblPatient had a new record added to the top of the table. It had "#"'s in all the fields and the odd thing was that the record somehow was saved without a key field (auto number).
So, now I am unsure what to do - what happened? I think the DB got corrupted and the compact and repair fixed it sort of. Is that correct?
-Can I delete the MSysCompactError table or does it have to remain in the back end?
-What do I do about that new record in tblPatient - Delete it? It serves no purpose as far as I can tell, although if I do it turns out that tblPatient will be short 1 record when compared to the back-up I did before I started this. I am not sure what record was deleted yet, but I am searching.
Thanks for any help.
So at that point, I decided to run Tools>Database Utilities>Compact and Repair Database... on the front end. Nothing happened. Then I ran it on the back end, opened the front end and everything (Forms, dropdowns, queries etc) worked correctly, except that the first record in the main form contained a bunch of "#" in all fields.
That seemed funny to me so I opened the back-end and looked at the list of tables and noticed a MSysCompactError Table appeared (attached). Also, the tblPatient had a new record added to the top of the table. It had "#"'s in all the fields and the odd thing was that the record somehow was saved without a key field (auto number).
So, now I am unsure what to do - what happened? I think the DB got corrupted and the compact and repair fixed it sort of. Is that correct?
-Can I delete the MSysCompactError table or does it have to remain in the back end?
-What do I do about that new record in tblPatient - Delete it? It serves no purpose as far as I can tell, although if I do it turns out that tblPatient will be short 1 record when compared to the back-up I did before I started this. I am not sure what record was deleted yet, but I am searching.
Thanks for any help.