Test Connection failed while exporting from Access to SQL SErver 2008 R2


I am importing data from access to SQL SErver 2008 R2 using IMPORT / Export Wizard.

But as soon as I select Source as Access and enter my admin username and password, I get following error message :

Microsoft Data Link Error :

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.

Any inputs ?


more ▼

asked Oct 20, 2011 at 12:01 PM in Default

avatar image

41 11 14 15

Are you running this on X64 machine?

Oct 20, 2011 at 12:07 PM Pavel Pawlowski

I am running on Windows Server 2008 R2. And I am using 32 bit import wizard. At that I am getting above error message.

Oct 20, 2011 at 12:17 PM jerill

Any idea wat is causing that error message

Oct 20, 2011 at 12:41 PM jerill
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 20, 2011 at 12:01 PM

Seen: 1237 times

Last Updated: Oct 20, 2011 at 12:01 PM

Copyright 2018 Redgate Software. Privacy Policy