• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

How To Fix Access 2010 with Password Import into SQL Server 2012 Error

When I use the SQL Server Management Studio Import/Expert Wizard to import tables from an MS Access 2010 database with a password into SQL Server 2012 Standard Edition, I get the attached error. Importing database tables without passwords works without errors. How can I fix this error?

Import Error
0
Chuck Wood
Asked:
Chuck Wood
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use the Data Link properties to specify a database password, or the path to you workgroup file and username/pass.
0
 
Chuck WoodAuthor Commented:
I did specify a database user name and password in the Data Link Properties and that is when I received the error.

Data Link Properties
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You need to click the Advanced button, then click the All tab, and use the Edit Value button there. YOu can specify quite a few different bits of info, like the DAtabase password, the System database, etc.
0
 
Chuck WoodAuthor Commented:
Excellent solution. I just removed the user name and password and set the  Jet OLEDB: Database Password in Advanced => All and it worked. Thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now