When I run the append query, I get message Record is deleted, I tried to find out and found out it means database is corrupted, but is there any way I can check if there is some particular corrupted record in the database or it must be the whole database. What can be done to get it fixed?
-
-
1) Backup your DB
2) You can try to do a Compact And Repair (repeat it a few times, if the first doesn't work) The problem with this method in my oppinion is that I don't really got told "what" was repaired, so I am unsure of how much data-corruption may have occured, or if its simply clearing teh cache so to speak. However, the Compact and Repair is pretty much the only thing I know of.
3) Create a new blank DB, and import all your modules/forms into that blank DB. You will need to reset the relations, and startup properties. I've heard this can help.
Comment