Should be too easy

[Fatih235]

Hey all;

I have a very simple question.I am using Access for database and now i put a password to it to make it secure.
What is the syntax to implement this password in my asp pages so that database interactivity can be done?My existing code is ;

Set MyConn=Server.CreateObject("ADODB.Connection&quot
MyConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("pc.mdb&quot

 

[Shahroozj]

Dear Sir

you can use following Code :

ConnectString = "Your Connection String"
DBUsername = " Your UserName "
DBPassword = " Your Password "

DBConn.Open ConnectString, DBUsername, DBPassword

Better than above is that you set this variable as Application Variable Like This :

Application("ConnectString&quot = "Your Connection String"
Application("DBUsername&quot = " Your UserName "
Application("DBPassword&quot = " Your Password "

call this variable in your first page and then use them in all of your pages like this :

DBConn.Open Application("ConnectString&quot,Application("DBUsername&quot,Application("DBPassword&quot

Regards

 

[codestorm]

or if you wanted to keep it as you current have it ..

Set MyConn=Server.CreateObject("ADODB.Connection&quot
MyConn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & Server.MapPath(&quot;pc.mdb&quot & &quot;;pwd=<password here>&quot;

(I try to avoid IIS Session and Application variable use wherever possible) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
You're not a complete programmer unless you know how to guess.
I hope I never consider myself an 'expert'.
<insert witticism here>