Link to home
Start Free TrialLog in
Avatar of LeighWardle
LeighWardleFlag for Australia

asked on

VB6 DAO - importance of registering DAO350.DLL

Hi Experts,

I have a number of VB6 applications that use DAO 3.5.

There are 100s of users happily using the applications on Windows XP, 7 and 8.x

But I have struck a problem when I run my setup programs (created with Setup Factory) on my Windows 10 Pro system.

I'm getting this error when running the setup program:
Error      Register COM file: C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\DAO350.DLL - System Error # 0 (3)
Notice      Register COM failure reason: Error 0x8002801c: Error accessing the OLE registry.

The installed application runs fine - I don't get any errors when using database features.

What I want to know is:  

does it matter to end users if DAO350.DLL is not registered?
can I assume that DAO350.DLL only needs to be registered for developers?
Regards,
Leigh
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

I'd be curious as to exactly what reference is being used on that Win10 box. Can you add code to show the references in use by the application? I know that Access can "upgrade" references to a newer version, so I'm curious if VB6 will do the same.
<<does it matter to end users if DAO350.DLL is not registered?>>

  Yes, DAO will not work.

<<can I assume that DAO350.DLL only needs to be registered for developers?>>

 No.   If VB6 makes a DAO call, it's going to fail if the DLL is not registered.

@Scott,

  No, references don't auto update.  That's an Office only thing.


Usually this error stems from 32/64 bit differences.   Make sure your using regsrv32 in c:\windows\sysWOW64 \ and registering with elevated admin priv.

Jim.
BTW, you really should be using DAO 3.61 rather than 3.5, which is the last release of DAO.

Jim.
The installed application runs fine - I don't get any errors when using database features.

I was curious about the above, if the DLL reg fails. If DAO isn't registered at some level, then the app should not be able to use it. Perhaps DAO35 is already registered on the Win10 box somewhere else?
SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LeighWardle

ASKER

Hi Jim and Scott.

Thanks for clarifying the situation for me.

Regards,
Leigh