Solved

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

Posted on 2010-08-25
1
962 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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