<div>
You can use the Data Link properties to specify a database password, or the path to you workgroup file and username/pass.
</div>


You can use the Data Link properties to specify a database password, or the path to you workgroup file and username/pass.

<div>
I did specify a database user name and password in the Data Link Properties and that is when I received the error.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/04_w16/908304/Password.jpg" target="_blank" title="Data Link Properties (65 KB)"><img alt="Data Link Properties" class="file-block lazyload" style="max-width: 377px;" data-src="https://filedb.experts-exchange.com/incoming/2015/04_w16/908304/Password.jpg" /></a>
</div>


I did specify a database user name and password in the Data Link Properties and that is when I received the error.

Data Link Propertieshttps://filedb.experts-exchange.com/incoming/2015/04_w16/908304/Password.jpg

Password.jpg

<div>
Excellent solution. I just removed the user name and password and set the &nbsp;Jet OLEDB: Database Password in Advanced =&gt; All and it worked. Thank you very much.
</div>


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.

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/04_w16/908172/ImportError.jpg" target="_blank" title="Import Error (36 KB)"><img alt="Import Error" class="file-block lazyload" style="max-width: 462px;" data-src="https://filedb.experts-exchange.com/incoming/2015/04_w16/908172/ImportError.jpg" /></a>
</div>
</div>


ImportError.jpg

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?



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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.