How to connect password protected access database file with windows form.

Question

0.00/5 (No votes)

See more:

<add name="dbinfo" connectionstring="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB\DBInfo.accdb;Persist Security Info=True;Jet OLEDB:Database Password=arthdata123"> providerName="System.Data.OleDb" />

What I have tried:

when i was debug windows app with database error is comming.."Not a valid password". how can i properly run my windows app with password protected database file.

<configuration>
<configsections>

<connectionstrings>

<add name="dbinfo" connectionstring="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB\DBInfo.accdb;Persist Security Info=True;Jet OLEDB:Database Password=arthdata123">
providerName="System.Data.OleDb" />

Posted 4-Feb-16 23:23pm

Arth01

Updated 4-Feb-16 23:28pm

v3

Add a Solution

Comments

Anisuzzaman Sumon 5-Feb-16 5:57am

which access database you are using (*.mdb) or (*.accdb)?

Arth01 8-Feb-16 3:47am

*.accdb database

dan!sh 5-Feb-16 5:57am

Have you provided correct password in connection string?

vipan.net 5-Feb-16 6:52am

Kindly verify your password . if its verified. Kindly shared your connection string .

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anisuzzaman Sumon · Accepted Answer · 2016-02-05T00:10:00

Solution 1

Your ConnectionString should be as follows
If you are using .accdb(Access Office 2007)

C#

"Provider=Microsoft.ACE.OLEDB.12.0;Data source=yourDatabase.accdb;Jet OLEDB:Database Password=yourPassword"

Similarly if you are using *.mdb file your connectionstring should be look like as follows

C#

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourDatabase;
Jet OLEDB:Database Password=yourPassword;"

Posted 5-Feb-16 0:10am

Anisuzzaman Sumon

Updated 5-Feb-16 1:43am

v2

Comments

Anisuzzaman Sumon 5-Feb-16 7:38am

hey boss why down vote???

Richard MacCutchan 5-Feb-16 7:54am

Idiots exist everywhere. I have countered with a +5.

BillWoodruff 5-Feb-16 18:51pm

+5

Arth01 8-Feb-16 3:40am

Thanks for reply
but also there was error coming "Not a valid password" then what can i do..

code in .config file is following..

<add name="dbinfo" connectionstring="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DB\DBInfo.accdb;Jet OLEDB:Database Password=arthdata123" providername="System.Data.OleDb">

Anisuzzaman Sumon 8-Feb-16 8:32am

You most welcome keya. :)

Arth01 13-Feb-16 1:01am

thank for support error was solved..