Forum Discussion

luriens's avatar
luriens
Copper Contributor
Jul 12, 2021
Solved

Ouverture base Access incorrecte

Bonjour, Quand j'ouvre une base Access qui a été créée sur un autre ordinateur, je n'obtiens qu'une table "MSysCompactError" qui me signale (sur plusieurs lignes) dans la description de l'erreur : "...
access
  • luriens's avatar
    luriens
    Jul 13, 2021

    isladogs 

    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

isladogs's avatar
isladogs
MVP
Jul 12, 2021

The MSysCompactError table is crested automatically when a compact and repair routine fails for any reason. This can happen if the database is closed by the user during the compact routine.

 

It may indicate there is data corruption or it may be possible to ignore it

Unfortunately your screenshot is almost illegible so I can't tell. Certainly there are a lot of errors flagged.

 

Try copying the MSysCompactError table to another empty database and upload that.

As its in French I may not be able to understand it, but hopefully someone else can even if I am unable to do so.

isladogs's avatar
isladogs
MVP
Jul 12, 2021
Better still can you upload a copy of your database?
  • luriens's avatar
    luriens
    Copper Contributor
    Jul 13, 2021

    isladogs 

    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

    • isladogs's avatar
      isladogs
      MVP
      Jul 13, 2021

      luriens 

      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.asp

      Recompile, 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.

      • luriens's avatar
        luriens
        Copper Contributor
        Jul 13, 2021

        isladogs 

        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

Resources