how do create connection string in csharp for password protected access database

Question

1.00/5 (1 vote)

See more:

hi all

in my csharp application i want to set connection string for password protected access database ...

i create access databse with this way :

open database with Exclusive and set password ...

now i create connection string like below :

public static string strconnection = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\FDA_DB.mdb", Application.StartupPath.ToString())+";Jet OLEDB:Database Password=12345;";

but it not work ...

please help me

thanks a lot

Posted 17-May-13 8:00am

Esmaeil Ebrahimi

Add a Solution

Comments

[no name] 17-May-13 14:08pm

"but it not work" is not at all helpful or describe any kind of a problem.

2 solutions

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)

OriginalGriff · Answer 1 · 2013-05-17T08:15:00

Try setting up a connection in VS with the Server Explorer pane:
1) Open Server Explorer.
2) Right click "Data connections" and select "Add connection"
3) In the dialog that follows, select your DataSource ("Microsoft Access Database File"), and database, specify the security info, and press the "Test connection" button.
4) When the connection works, press "OK"
5) Highlight your database in the Server Explorer pane, and look at the Properties pane. A working example of the connection string will be shown, which you can copy and paste into your app or config file.

PIEBALDconsult · Answer 2 · 2013-05-17T08:49:00

Solution 2

How about something more like:

test

public static string strconnection = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\FDA_DB.mdb", Application.StartupPath.ToString())+";Jet OLEDB:Database Password=12345;";;

public static string strconnection = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\FDA_DB.mdb;Jet OLEDB:Database Password=12345;", Application.StartupPath.ToString());

And do you need the ToString?

And should you be using JET? Or ACE? What error do you get?

Posted 17-May-13 8:49am

PIEBALDconsult

Updated 17-May-13 8:50am

v2

Comments

[no name] 17-May-13 15:02pm

when use syntax 2 of your post get this error : Not a valid password.

PIEBALDconsult 17-May-13 15:07pm

You may need to provide an ID and password. I use:

System.String.Format
(
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Jet OLEDB:Database Password={1};User ID={2};Password={3}"
,
System.Environment.ExpandEnvironmentVariables ( FileName )
,
Password
,
UserName
,
UserPass
)

and default to ID admin with an empty password.

[no name] 17-May-13 15:10pm

i write this but not work again :

public static string strconnection = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\FDA_DB.mdb;Jet OLEDB:Database Password=eepersian.ir;User ID=admin;", Application.StartupPath.ToString());

PIEBALDconsult 17-May-13 15:18pm

also add the empty password.

[no name] 17-May-13 15:30pm

when password empty get this error :

---------------------------
Microsoft Visual Studio
---------------------------
Entering break mode failed for the following reason: Source file 'E:\FDA\Project_FDA\Project_FDA\Class_Methods.cs' does not belong to the project being debugged.

Usually, this condition occurs when the project was not rebuilt prior to starting the debugging session, when the assembly file for the project is out of date, or when the project source files were moved to a different disk location between the time the project was built and the debugging session was started.

Edit and Continue will be disabled for this debugging session.
---------------------------
OK
---------------------------

PIEBALDconsult 17-May-13 16:04pm

Did you really supply an empty password?

[no name] 17-May-13 15:31pm

in fact i want end user can not open access database and only my program cat work with it ...

is there any other sulotion ?