DAO problems

[capone67]

Hi Gang

I am trying to implement an activeX controlthat will create a database on the fly. I implemented it using DAO but it doesn't run on a system that doesn't have DAO installed already. The user would need to create a folder, copy a file and then use regsvr32. This is not an option. So I moved on to DAOX and have gotten it to run locally as well, but when I go to a system that does not have VB installed already on it the control craps out yet again.

Does anyone know what it takes to get an activeX control that can create a database to download over the net and run properly on a local system?

Ken

PS I have been discussing/learning ADOX extensively in the VB 5 & 6 forum but have just gotten to this hurdle of getting it to run on another system. The title of that thread is "DAO Problem?"

 

[DougP]

If you created an Install package wouldn’t it register the Active X on installation?
I have done this and it works great.
Sometimes you have to re-boot twice depending on the age of Windows 95 operating systems.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[capone67]

Hi Doug

I am testing on two systems. One is Win98 and should be SR1 since the system was purchased in the fall, and the other is Win 2K.

I have also had it tested out of office on another system, not sure of its specs, and it doesn't work there either.

Ken

 

[chiph]

> but when I go to a system that does not have VB installed already on it the control craps out yet again. <

You need to package the MDAC_TYP.EXE with your setup program. Yes, it's huge. Yes, it can require multiple reboots on some releases of Windows. But trying to track down the different DLLs and other files and registry settings required for your app to run is a tremendous pain. Plus, if you miss one, or if you install a version intended for Win2K onto a Win98 machine, you could make the PC unbootable.

Safe money is on distributing the MDAC file with your app.

Chip H.