VB and Database project installation

[netom]

Hi there!
Recently I finished work on application, which uses vb database controls (Data component) for access to Access database (*.mdb files). Everything works fine in my work environment (Win98 and VB6 Enterprise installed) but problems start when I want to make installation of my program (exe and two mdb files) and to setup it on other computers. InstallShieldv6.0 recognizes that my application is database project and besides my application and data files copies numerous dll files (like msjet350.dll, etc.). But when I install that prepared distribution under clean Win95 or Win2000 my program prompts me with “Class not registered Looking for object with CLSID {...}. “ message box.
I even made a simplest program: one form and one data control with connection to dbf file and again the same message would appear. That left my thoughts that something is wrong with my application. Then I tried with “Package and Distribution Wizard” (Microsoft add-in for VB) but the results where the same. My main thought is that installation doesn’t create registry keys with values that are needed for access components to work (I even tried to manually copy some of them, believe me).
Regard,
Netom

[Tower]

After your installation programm run MDAC install and you not have any problem. This is good idea.

[netom]

I've tried already with installation of MDAC2.5 but however the problem had remained. The application just hangs out with message box “Data Access Error”. I just can’t believe that it is so hard to make reliable setup of database project made with VB (and I have to remember how it was easy under Delphi). I’m kind of disappointed :(
Regards,
Netom

[bill brave]

On my opinion, problem is at registering dll files.
So after you use Package Wizard, collect some needed dll files and try to install them manually.
(Regsvr32.exe)

If all dll files have been installed correctly, I think your app must run.

Let me know if it help you.

[netom]

Thanks to your post now application after installation works perfectly! The main problem was one of the dao files, which didn't registered after installation. I used resvr32.dll (looked up in MSDN info about this utility) and application finally prompted me with main dialog! Again, thanks very much! :)
CU
Netom