MS Access 2007 Database - Provider Not Found Error

2013 8 27
1 个回答
3 次查看（30 天）

0 个投票

I'm having trouble connecting to an Access Database.
Using "PROVIDER = Microsoft.ACE.OLEDB.12.0;" returns a "Provider cannot be found." error when invoking the Open command.
I have freshly reinstalled MDAC (32-bit), and I don't have any trouble using Access 2007 on the target machine. The machine is a Win7 Enterprise SP1 and I'm using MatLab R2012b.
I can only theorize that some library of component is missing, but I don't know what it could be.
Advice would be appreciated.

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Walter Roberson
Walter Roberson 2013-8-27
Are you running MATLAB in 32 bit or 64 bit mode ?
mark
mark 2013-8-27
I'm not sure. 64-bit OS and processors, but I'm not sure how to check the bit mode I'm running in.
Walter Roberson
Walter Roberson 2013-8-27
Does
computer
at the command prompt report 'PCWIN' or 'PCWIN64' ?
mark
mark 2013-8-28
PCWIN64. So I'm running in 64-bit mode. Can I switch over to 32-bit mode, or do I need to have the 64-bit MDAC installed?
Walter Roberson
Walter Roberson 2013-8-28
You can also install 32 bit MATLAB and run that (on the same system. no additional license needed)
mark
mark 2013-8-28
I'll see which of those is easier.

请先登录，再进行评论。

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

回答（1 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

产品

标签

提问:

mark
mark
2013-8-27

Community Treasure Hunt

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

Start Hunting!

Translated by