Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jake Shelton
Yak Posting Veteran
74 Posts |
 Posted - 2012-02-03 : 10:34:55
|
| Hi all, errors out as follows when attempting import: "Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user"I'm using SP3 which should get me in, and my password is correct as I can access via....Access!Any idea how to complete this import? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-03 : 10:59:35
|
| seems like problem in access connection manager used. which provider are you using?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Jake Shelton
Yak Posting Veteran
74 Posts |
Posted - 2012-02-03 : 11:00:33
|
| The generic MS one for Access |
|
|
|
Jake Shelton
Yak Posting Veteran
74 Posts |
Posted - 2012-02-03 : 12:36:53
|
| Any ideas? I'm trying to run this from the Import/Export wizard. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-02-03 : 14:30:03
|
| create a copy of this access file elsewhere and try to import and see what happens. could be someone else/process has it lockedIf you don't have the passion to help people, you have no passion |
|
|
|
Jake Shelton
Yak Posting Veteran
74 Posts |
Posted - 2012-02-03 : 14:32:22
|
| Tried that, same result. Also (within Access) upgraded the version to 2002, still no go. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-02-03 : 14:36:01
|
| what security context is the ssis package running? sa, you or what?If you don't have the passion to help people, you have no passion |
|
|
|
Jake Shelton
Yak Posting Veteran
74 Posts |
Posted - 2012-02-03 : 14:46:33
|
| On my own machine with full SA rights. |
|
|
|
Jake Shelton
Yak Posting Veteran
74 Posts |
Posted - 2012-02-04 : 04:27:31
|
| I should add that I can see the table schema in BIDS, I have also been able to extract data per table, but I don't know how to perform a full DB copy in it. |
|
|
|
|
|
|
Error importing from Access '97