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.