Solved

"Unable to initialize DAO/Jet db engine" error from CDaoDatabase() class

Posted on 2006-07-11
13
2,794 Views
Last Modified: 2012-08-14
Not sure if this is an ACCESS question or a programming question but I'll start here...

I have a MS Access database, db.mdb, that is accessed by a C++/MFC program using the CDaoDatabase class as such:

      CDaoDatabase *pDatabase = new CDaoDatabase();
      pDatabase->Open("C:\\<some_path_to_the_folder>\\db.mdb");

      CDaoRecordset rs(pDatabase);

It's worked fine for months, perhaps years.  But today it's started reporting a dialog that says:

"Unable to initialize DAO/Jet db engine"

when the line:

      pDatabase->Open("C:\\<some_path_to_the_folder>\\db.mdb");

is executed.  Not sure what's going on or what has changed but I'm baffled.  As far as I can tell, Access itself runs normally on this database.  So I suspect it's some issue with DAO but I'm not sure how to fix it.

This is running on XP SP2 and I tried to install the MDAC 2.8 SP1 but get an error that says:

"This setup does not support installing on this operating system"

Ok, I think that because XP SP2 INCLUDES MDAC 2.8 and will not install again.  I did try installing MDAC 2.7 but that didn't seem to make any difference.
0
Comment
Question by:jhance
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 4
13 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 17081879
is it only on one machine?
if so I think we can find the list of files you may need to unregister / re-register.

Steve
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17081883
DAO is part of the Jet engine not the MDAC since about MDAC 2.5
0
 
LVL 32

Author Comment

by:jhance
ID: 17081943
This is a one-off application.  So yes, it's only on one machine.


jimpen,

Ok, so DAO is a part of the Jet engine.  Any suggestions on how to fix this?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 38

Expert Comment

by:Jim P.
ID: 17081960
0
 
LVL 39

Expert Comment

by:stevbe
ID: 17081974
right ... dao is part of the OS and not MDAC so it could have been installing XP SP2

this KB talks about 95 but I think the register part still applies
http://support.microsoft.com/kb/q177264/

Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll
0
 
LVL 32

Author Comment

by:jhance
ID: 17082004
jimpen,

When installing the KB you suggested I get:

KB829558 Setup Error

Setup has detected that the Service Pack version of this system
is never than the update you are applying.

There is no need to install this update.
0
 
LVL 32

Author Comment

by:jhance
ID: 17082022
stevbe,

I did:

Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll

on my system and got the message that it was successfully registered.  Unfortunately, the problem remains.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17082041
Ok.  Then follow stevbe's suggestion for the regsvr32.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17082064
Does C++ have its own DAO dll of some sort?
0
 
LVL 32

Author Comment

by:jhance
ID: 17082175
I don't know, if there is, it's not obvious.
0
 
LVL 39

Accepted Solution

by:
stevbe earned 500 total points
ID: 17082328
Sorry, that dao350.dll was for 95, please re-register dao360.dll (that is the latest and greatest)
0
 
LVL 39

Expert Comment

by:stevbe
ID: 17082333
should be in ...

C:\Program Files\Common Files\Microsoft Shared\DAO
0
 
LVL 32

Author Comment

by:jhance
ID: 17082504
That did it...  Thanks!@!
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question