Database Question

[lambela8]

I have a program that accesses an Access 2000 database that is located on an NTServer. The program is run locally but accesses the server. Out of 30 computers, about 5 have a hard time connecting and take 2 minutes to load every form that takes the rest of us 2 seconds. I am using DAO, but tried using ADODC on one form to see if that would help and it does not.

Does anyone have any suggestions as to what is going on? (One final thought ---- I started this program in vb6.0 and I do use the datacontrol. On new computers, when opening up those forms I do get a class not registered error. The install includes the dll's and ocx's, but I have to manually install them myself for it to work.)

Also how do you use ADODC with a password protected database that's on the server. (Using Jet 4.0). It works with ODBC, but not Jet 4.0. It keeps saying workgroup information file missing.

Any help would be appreciated.

[Clunietp]

Open password protected database via ADO: http://vbcode.webhostme.com/en/click.asp?id=86

What is the CLSID/GUID of the unregistered component?

If you are using DAO 3.6 to connect to your Access 2K database, check this link for distribution info: http://support.microsoft.com/support/kb/articles/q233/0/02.asp

[lambela8]

I will have to do another install to get the classid info. Thanks for you help on the ADO password question.

I wrote a program in VB5.0, and another one in VB6.0. We got some new computers and installed the vb6.0 one first. The computer has Windows 98. I get the classid error only when opening a listbox attached to a datacontrol. Other parts work perfect. I then install the vb5.0 program and magically, the first one starts working. There has to be a file the vb6.0 setup isn't installing properly.

I do use the mdac and dao 2.1 install, so everything should be fine there.

[Clunietp]

Well, let me know when you get the CLSID info, I can find it in the registry and let you know, probably DAO350.DLL.....

[lambela8]

Ok, I now know the problem. DAO 3.6 is not installed correctly for some reason. So I need some help. Very few computers were getting Runtime Error 3633 - because dao3.6 was not installed. I looked at the website you gave, but when I run Regsvr32 dao360.dll, all I get is LoadLibrary(dao360.dll) failed.

How can you register a dll in the standard setup of VB?

By the way, the classid problem was the dao3.6 problem as well. If I installed a vb5.0 application, it put the dao3.5 dll on the computer which took care of the classid.

If I would've know Access 2000 would cause this much problem, I would've stayed with 97.

[Clunietp]

You must be incorrectly registering the DAO360.DLL because I can register it fine...

[lambela8]

I am at work now and run the same thing that I did at home and it works perfectly here.

I have windows 98 at home, so maybe that's it. How could I run regsvr32 in code with the install? Any ideas?

[Clunietp]

Your installer SHOULD do that for you....