Forum Discussion
Ouverture base Access incorrecte
I am sending you a copy of the MSysCompactError table in Excel.
It is difficult for me to send you a copy of the database because it contains personal data of members of an association and I have to respect confidentiality.
Thank you for your help
Thanks. I only needed you to send that system table in a new blank database.
Anyway, having looked at the Excel file, there are errors in ALL your system tables...including several that are deep hidden and some that are usually empty. In addition, you have errors in four record sources used in forms, report including any combos or listboxes (those beginning ~sq_...) and two reports(?) beginning rqt...You almost certainly have data corruption and may well have corrupted code as well.
First make a backup just in case. Next import all objects into a new blank database. Make sure you tick the options in the Import dialog box. System tables will NOT be imported. New tables will be created automatically
Next, make a new backup then compile your project fixing any errors. Now DECOMPILE to remove any corrupted code. See http://www.fmsinc.com/microsoftaccess/Performance/Decompile.aspRecompile, backup once more then compact the project.
Now check each of the items listed in the MSysCompactErrors table. Are they OK? If so, you're in luck. Otherwise you are going to have to create new objects to replace anything lost to corruption or retrive them from earlier backups if you have any.
After many unsuccessful attempts, I finally used Stellar Repair for Access and recovered the entire database (data, structure and code)... phew!
I thank you for the time you spent with me.
Best regards- Excellent. Glad it worked for you.
My own experiences with Stellar have been far less successful. To be fair, it depends upon the degree of corruption involved.