Importing Error (1 Viewer)

[muppetmad]

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]

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]

No other users were on. I did not realize I needed to be using the workgroup admin password when moving my data with DTS.