Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2010-08-25
1
Medium Priority
?
970 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

636 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