Discussion Locked

SQL - IMPORT/EXPORT DATA

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Unable to import data from Access .mdb file into SQL 2000 database. Error menu: Microsoft Jet Databse Engine: Cannot start your application . workgroup information file is missing or opened exclusively by another user. Context: Error during intialization of the provider.
what is the solution to this error?

3 replies

by moxymeehan

FYI :-

1) The Microsoft Access database is not a secured database and the login and
password specified was not Admin with no password.

2) 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.

This discussion is closed to new replies.