DAO and VB Error [Solved]

[eckotek]

hello,

I have been searching and cant find the answer. Im using DAO 3.5 with Access 97 database and I keep getting an Active X error when i try to open the app. when i use the vb P&D i still get the same error and i dont know what i am missing.

Im testing this on multiple machines with fresh installs. What can i do to make sure everything works without getting this active x error.

[graySteel]

Hi

An ActiveX error will occur only when you are missing some .dll or .ocx. Cross check whether you have included all the dll and the ocx you are using in your project in the PDW. I remember doing this have resolved this issue.

Gs

[eckotek]

I have spend hours looking for any missing .dll's or anything else. Nothing I keep getting that stupid ActiveX component cant create object. What else can i do? P&D wont even add the right files to make it work.

[Currently testing on a fresh install on Windows XP Pro]

[Shaggy Hiker]

DAO 3.5 or DAO 3.51. Perhaps they are the same thing. It seems to me that 3.51 worked for Access97, but not 2000. That's just my memory, but it may be faulty. Without looking it up, I'm not sure, but I would suggest that you try a newer version of DAO, and see if that solves it.

[kleinma]

are you distributing MDAC with your app?

[eckotek]

Shaggy Hiker:

I will go ahead and try a newer version see if it works.

Kleinma:

Yup using the P&D it distributes MDAC 2.0 and it install's it while installing the application, but for some reason i still get that activeX error. doing database apps seems to be a headache.

[Vishalgiri]

Why don't u use ADO.

[eckotek]

When i was browsing on how to connect access to VB, thats the example i found so i worked off that.

[eckotek]

Thank you for everyones help!!! I was able to obtain InstallShield from my friend and that did the job.

Thanks again to everyone that tried to help!

[shragel]

Originally posted by Vishalgiri
Why don't u use ADO.

What difference does it ake to u what he uses?