This is a the discription of the error message I get, the odd thing is that I am not trying to connect to an Access database I am trying to connect one SQL 2K box to another?????
Severity Level 16
OLE DB provider '%ls' reported an error. %ls
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
This error message returned by the Microsoft OLE DB Provider for Jet indicates one of the following:
The Microsoft® Access database is not a secured database and the login and password specified was not Admin with no password.
The Access database is secured and the HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\SystemDB registry key is not pointing to the correct Access workgroup file. Secured Access databases have a corresponding workgroup file, including the full path, which should be indicated by the above registry key.
Verify that there is a login mapping for the current Microsoft SQL Server™ login to Admin with no password.
If the Access database being accessed is secured, make sure that the above registry key points to the full pathname of the Access workgroup file.