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?