I've run into the problem where a small project I ran from my personal 

machine now is to be part of our entire department on a central server.



I used DSN and a non-secured database before.  I've since given the 

database a password and changed my code to be DSN-less.



I overcame the "Can't start your application. The workgroup information 

file is missing or opened exclusively by another user. (Error 3028)" error 

to be hit with the "Could not find installable ISAM. (Error 3170)" error.  

I went to the Microsoft site and they told me:

"This file is required for linking external tables (other than ODBC or 

Microsoft Jet database tables)."  Why do I need this linking when the 

tables are in Access97?



I checked the registry entires, and they appear to be pointing to the 

correct dlls in my WINNT\system32 directory.



Here is my connection string:



strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; _

Password=new; _

User ID=admin; _

Data Source=C:\Inetpub\wwwroot\training2\training2.mdb; _

Extended Properties=""Password=training2""; _

Persist Security Info=True; _

Jet OLEDB:System database=C:\inetpub\wwwroot\training2\Training.mdw"



If I try changing the provider to Microsoft.Jet.OLEDB.3.5 I get "ADO could 

not find the specified provider."



I want to secure the database since it has sensitive material in it, but 

right now I'm running DSN-less with no passwords.



Does anyone have a solution to this problem?