none
By access2010 error after opening in Access2013 (mdb) RRS feed

  • Question

  • There is a base, is on a file server,clients are different - 2010 and 2013.

    Our database uses open Excel by entering data to it.

    2013 newly delivered, but after working in it (without any editing or even data entry) at the opening of 2010 gets the error "the file Search Excel.exe" and then of course, when you try to open Excel "Compile error Can't find project or library" in VBA on a line of opening in Excel.

    Most interesting is that there are a couple of databases that are there, without any problems, Excel in them, but one is the opening Word, also transfer data to it. Everything is fine.

    What to do with it?


    Friday, July 27, 2018 11:51 AM

Answers

All replies

  • I'd ask for help over here.

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access

     

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Friday, July 27, 2018 12:18 PM
    Moderator
  • Try this sequence in order:

            • Backup. Make a backup copy of the bad database, without overwriting any existing backups. Whatever has gone wrong, you don't want to make it worse, and a backup gives you multiple attempts at recovery.
            •  try to use access file repair
            • Uncheck the Name AutoCorrect boxes. In Access 2007:  Office Button | Access Options | Current Database. In previous versions:  Tools | Options | General.
            • Compact. In Access 2010:  Compact and Repair Database on the Database Tools ribbon. In Access 2007:  Office Button | Manage | Compact/Repair. In previous versions:  Tools | Database Utilities | Compact/Repair.
            • Decompile. Close Access, and enter something like this at the command prompt:     "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\MyPath\MyDatabase.mdb" Use the path to where msaccess.exe is found on your computer, and include the quotes.
            • Compact again. Open Access (holding down the Shift key if you have any startup code), and compact again. Do this twice: one compact does not work in all versions (unless you close Access between step 4 and 5.)
            • Set minimal references. Open a code window. Choose References from the Tools menu. Uncheck any references you do not need. For a list of the ones you typically need in your version of Access
            • Compile. Still in the code window, choose Compile from the Debug menu. Fix any errors, and repeat until the code compiles okay.
            • Set code options. Still in the code window, choose Options on the Tools menu. On the General tab, make sure Error Trapping is set to "Break on Unhandled Errors", and Compile On Demand is unchecked.

    At this point, you should have a database where:

    • the Name-AutoCorrect errors are gone,
    • the indexes are repaired,
    • inconsistencies between the text- and compiled-versions of the code are fixed,
    • reference ambiguities are resolved,
    • the code syntax is compilable, and
    • the VBA options are set to show errors and avoid this kind of corruption.
    Sunday, July 29, 2018 3:58 PM
  • This is "where is" forums for direction on where best to ask question. For msaccess issues I'd ask for help over here.

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access

     

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Monday, July 30, 2018 12:49 PM
    Moderator