Hello
I'm trying to build a (very) simple simulation that accesses a data variable from MS Access (2007). I have a table called "CurrentValues", with a couple columns named Station1Pressure and Station1Temperature.
For my sim, in the first instance, I just want to read in (DBRead step) in the values; so, I have process that reads the value when I click a button.
Eventually, I want to update the database value with a form in Access and see the change when I click the event button in Simio.
Note: The database (Sample.accdb) and the sim are in the same directory.
First problem is, after I define the Element reference (DbConnect), I set the "Connection String" to the database file, (Sample.accdb) and the "Provider Name" to "Microsoft.ACE.OLEDB.12.0" as noted in another post. Unfortunately, I get the error attached.
(I'll start with that since if I can't get through the first step, the following ones are irrelevant.)
Thanks