Troubleshooting Connection to Microsoft Access File

I am fairly new to databases and I need to figure out how to open and obtain values from a Microsoft Access file. So far, I have not even been able to establish a connection to the file using the code shown:
>> conn = actxserver('ADODB.Connection');
>> invoke(conn,'OpenCurrentDatabase','<Path.MDB>');
I get the error:
>> Error using COM.ADODB_Connection/invoke
I've done a lot of googling and all suggestions have not seemed to help. For some clarification, I don't have the database toolbox and the MDB file was created with an older version of Access than is currently installed on my machine, could this be a potential issue?
Thanks for any potential help anyone can provide, AB

3 Comments

Can you buy the toolbox? You can get a free 30 day evaluation first if you want.
I could possibly, that would be a company issue I'd have to see about. The fact is that people have claimed that this methodology would allow for me to connect to a database without the toolbox. I only need to pull information from a MDB file, so I feel like the toolbox might be overkill.
Is there any way I could investigate the error further to see what is causing it? Perhaps that will lead me to where I need to go.
After more researching, still nothing works. Any help with troubleshooting this problem? Do I need a version of Access installed on my machine that is the same version as the DB was made in? Drivers for DBs?

Sign in to comment.

Answers (0)

Products

Asked:

on 9 Dec 2015

Commented:

on 14 Dec 2015

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!