MS Access 2007 Database - Provider Not Found Error

27 Aug 2013
1 Answer
2 Views (30 days)

0 votes

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 Comments
Show 4 older comments Hide 4 older comments

Walter Roberson
Walter Roberson on 27 Aug 2013
Are you running MATLAB in 32 bit or 64 bit mode ?
mark
mark on 27 Aug 2013
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 on 27 Aug 2013
Does
computer
at the command prompt report 'PCWIN' or 'PCWIN64' ?
mark
mark on 28 Aug 2013
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 on 28 Aug 2013
You can also install 32 bit MATLAB and run that (on the same system. no additional license needed)
mark
mark on 28 Aug 2013
I'll see which of those is easier.

Sign in to comment.

Sign in to answer this question.

Answers (1)

Stew
Stew on 22 Sep 2013

0 votes

Recover given issue via ms access database fixer
Look into http://www.msaccessfixer.accdbfix.com

Categories

Find more on Database Toolbox in Help Center and File Exchange

Products

Tags

Asked:

mark
mark
on 27 Aug 2013

Community Treasure Hunt

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

Start Hunting!