Troubleshooting Connection to Microsoft Access File

2 次查看（过去 30 天）

Austin Burks 2015-12-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/259561-troubleshooting-connection-to-microsoft-access-file

评论： Austin Burks 2015-12-14

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 个评论
显示 1更早的评论隐藏 1更早的评论

Austin Burks 2015-12-10

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 2015-12-14

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?

请先登录，再进行评论。

请先登录，再回答此问题。