View Full Version : Importing Error


muppetmad
09-22-2008, 07:45 AM
I am trying to Import data from an Access 03 database to my SQL 2000 server. Whe I user DTS it allows me to enter my type (Microsoft Access) and give my location and a user name and password. Then it gives me the following error.

Error Source: Microsoft Jet Database Engine

Error Description: Canot start your database application. The workgroup information file is missing or opened exclusively by another user.

Context: Error during initialization of provider.

What does that mean?

SQL_Hell
09-22-2008, 09:05 AM
It means your database is opened by an administrator, who has exclusive access or your workgroup file is missing.

Check to see whether anyone has it open

muppetmad
09-23-2008, 11:17 AM
No other users were on. I did not realize I needed to be using the workgroup admin password when moving my data with DTS.