How to use c# with password protected Access Database?

Question

0.00/5 (No votes)

See more:

One of the apps I've been developing is next to done...and up until now I've used the Access database without specifying a password. But, for the final version, I want it to be secured with one...The problem is, I've tried setting a password in Access, it's ok....Then added the database within my project with the wizard in VStudio, but even if the connection test is ok, when trying to runn the app I get an error like "Not a valid password".
Any Ideas? The password i used is something like "aaaaaBbbbb", only literals, no numerals.

Posted 29-Mar-10 0:52am

galextudor

Updated 29-Mar-10 1:08am

Rajesh R Subramanian

v2

Add a Solution

4 solutions

Solution 4

Just as an FYI, access system passwords aren't all that secure. You can easily and quickly download a free utility to show the passwords in any Access database. They're very east to get into. If you want an example see hereL Download Access Password Retrieval LITE[^]

Just as an example though...here's one way to provide the password:

C#

connectionString = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" +
                                             "DataSource=" + dbLocation +
                                             ";Jet OLEDB:Database Password=" + password)

You'd be better off encrypting the file and decrypting it when you want to use it. An example at: How to encrypt and decrypt a file by using Visual C#[^]

Posted 29-Mar-10 8:05am

William Winner

Solution 1

You put the password in the connection string.

Posted 29-Mar-10 0:58am

Christian Graus

Solution 2

Looks like where ever you are setting the password, it's not getting saved. If there is an option to save password then use it. Or else you have to supply password using other ways... one already suggested by CG

Posted 29-Mar-10 1:37am

Sandeep Mewara

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)

Luc Pattyn · Accepted Answer · 2010-03-29T02:29:00

Solution 3

As always, the answer to DB connection questions should be right here[^].

:)

Posted 29-Mar-10 2:29am

Luc Pattyn