1 Reply Latest reply: May 15, 2014 9:52 AM by Tony Smith RSS

    OpenDatabase method

    Tony Smith

      I'm trying to use the OpenDatabase method in some VBA code.  The file I'm trying to access is an Excel file.  I've created a model and accessed the data in Monarch.  Now I'm trying to open the file and model in Microsoft Access.  I'm getting the following message after I run this job.

       

      Session started:    Monday, July 31, 2006 11:02

      Fields in model do not match fields in data source.

      Set model file:     C:NewCoARClient20MonarchFolderARModel2.xmod

      need to set model

      Session ended:      Monday, July 31, 2006 11:02

       

      So if the model works in Monarch why can't it work with the VBA code?

       

      Thanks

       

      Tony Smith

        • OpenDatabase method
          Tony Smith

          I'm trying to use the OpenDatabase method in some VBA code.  The file I'm trying to access is an Excel file.  I've created a model and accessed the data in Monarch.  Now I'm trying to open the file and model in Microsoft Access.  I'm getting the following message after I run this job.

           

          Session started:    Monday, July 31, 2006 11:02

          Fields in model do not match fields in data source.

          Set model file:     C:NewCoARClient20MonarchFolderARModel2.xmod

          need to set model

          Session ended:      Monday, July 31, 2006 11:02

           

          So if the model works in Monarch why can't it work with the VBA code?

           

          Thanks

           

          Tony Smith