Link to home
Start Free TrialLog in
Avatar of GuthrieTheater
GuthrieTheater

asked on

Imprort from Access db to SS 2005 failing: "cannot start your application"

I 'm trying to use the SQL Server 2005 Import / Export wizard to import data from a password-protected MS Access 2003 database, and though I know the password and provide this info to the wizard, the process fails at the "choose a data source" stage with this error:

The operation could not be completed. Cannot start your application. The workgroup information file is missing or opened exclusively by another user. (Microsoft JET Database Engine)

the file isn't open, so googling has lead me to information about the system.mdb file, which I copied from my PC to the SQL Server, and though I've tried a variety of locations for the file, the Import wizard can't see it.

I'd go with an excel or CSV export from the Access db, but I need to set up something I can use on an ongoing basis as the Access db is still in use.

Suggestions greatly appreciated! Thanks.--Chris
ASKER CERTIFIED SOLUTION
Avatar of GuthrieTheater
GuthrieTheater

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial