Migration data between servers corrupted MS Access db RRS feed

  • Question

  • Our old network server data was migrated to a new server, new location over the weekend. I have a customized reporting database which has been used for a dozen years and now has stopped access to doing coding after migration.

    Error messages read the following;

    Database has been placed in a state by user admin that prevents it from being opened or locked

    next message;

    Microsoft Access is unable to read the VBA modules of this database and cannot recover the modules because the file is read only.  To recover the VBA modules, close the database and make a backup copy of the database.  Then open the database with read/write permission.

    Third message;

    The VBA modules in this database  appear to have been saved with errors.  Access can recover the modules but you should back up the database first. 

    Computer services migraged all of these drives using "delta sync" and I am not familiar with what precautions/allowances should be made for MS Access Databases.

    Thanks in advance.

    Monday, May 6, 2019 3:33 PM

All replies