1 Reply Latest reply: May 15, 2014 10:03 AM by Grant Perkins RSS

    Cannot open external database

    Hal Latham

      I have a V10 project file that reads an Excel 2003 spreadsheet that is located on a server drive. I can close, refresh and reopen the original database in Monarch, but can't change the database to another Excel spreadsheet of the exact format in the same server directory. The error message I get is "Cannot open external database". Does anyone have ideas on how to deal with this problem?

        • Cannot open external database
          Grant Perkins



          Just to check understanding here.


          You have a Project that is saved pointing to a specific 'database' and its model.


          You open the project and attempt to select a different database and then get the error message.


          Can we assume that the basics have been checked - access rights, correct name (selected from a browse session or verified as types without typos), that the alternate database is indeed exactly identical, other than name (Field definitions, names and 'Names'), not open and locked in another application.


          Can the other file be opened in another Monarch session skipping the Project?


          Mostly basic stuff I'm afraid, but I have been caught out enough times by not checking such things accurately before diving off looking for a complex answer to a complex problem that I hope you will foregive me offering a basic tick list here.