I was previously using Origin2015 pro and I connected my Worksheet with the local MS access database via "Microsoft.Jet.OLEDB.4.0" and it worked perfectly.
However, now my company updated to Origin 2016 lately and I couldn't find that possible option under "Data Link Properties >> Provider" tab. How can I connect to a local MS access Db in Origin 2016?
This might be a simple question but pardon me, I am new to origin.
Make sure you are running the same "bit version" of Origin that you are running with MS Access/Office. For example, if you are running 64-bit Access/Office, run 64-bit Origin. Conversely, if you are running 32-bit Office, run 32-bit Origin. The database drivers should then be available.
Thanks, Chris Drozdowski Originlab Technical Support
Origin 2016: Ms Access connection string
Posted - 11/07/2016 : 08:41:15 AM
