Re: Cannot read data from Access 2007 database



dbouthillier wrote:
Hi. I'm trying to read data from an Access 2007 database. I'm working
with VS 2005 C++ on Windows XP SP2. I downloaded the 2007 Office
System Driver found at

You need the Microsoft Jet drivers. You need to download them separately
from the MDAC installer. however, i would be a little surprised if you
didn't already have the Jet drivers. Look for msjet40.dll on your system

(SUCCEEDED(m_oDatabase->Open("Provider=Microsoft.ACE.OLEDB.

I don't do C++ so I may be offbase here, but this does not seem like the
appropriate provider for Jet. You should be using the
Microsoft.Jet.OLEDB.4.0 provider.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.