Troubleshooting Connection to Microsoft Access File

1 view (last 30 days)
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
Austin Burks
Austin Burks on 10 Dec 2015
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.
Austin Burks
Austin Burks on 14 Dec 2015
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

Community Treasure Hunt

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

Start Hunting!