Solved

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

Posted on 2010-08-25
1
958 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:GuthrieTheater
1 Comment
 
LVL 1

Accepted Solution

by:
GuthrieTheater earned 0 total points
ID: 33524077
A brilliant e-mail correspondent gave me the solution: I needed to copy System.mdw from my PC to the server, then after launching the SQL Server 2005 Import / Export wizard, I specify the file but the leave the username and password fields blank, then click advanced and choose the "All" tab. Fill in the database password field there, and the path to the System.mdw above, in the corresponding fields, and I'm back in business.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now