database security issue

[omerbutt]

sir,
i am making an online appliation for submitting daily sales reports .i am using html dhtml asp and janvascript .the problem is if i apply password to the access database then it gives error "wrong password".what shud i do to secure ma database that it does not give any error while running any query in the program ,or while acessing the database,
thanks for help in advance

[MMcCarthy]

You have posted in the Articles section. I am moving this question to the Access forum.

ADMIN

[omerbutt]

You have posted in the Articles section. I am moving this question to the Access forum.

ADMIN

thanks ...
do give an answere too

[MMcCarthy]

thanks ...
do give an answere too

You haven't given enough information. How are you passing the password to the Access database. What code are you using to make the connection?

[omerbutt]

You haven't given enough information. How are you passing the password to the Access database. What code are you using to make the connection?

here is how i am making a connection .
<%
Set RSANCR = Server.CreateObject("ADODB.Recordset")
connectionstr= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb")
strsql = "SELECT MacModle.Modles FROM MacModle WHERE MacModle.Cat = 'COPIER'"
RSANCR.Open strsql, connectionstr , 2
%>
the password is applied manually aon the access data base means by opening it through the file->open and then open exclusive ....it is not applied through any code all i want is that no one can open it else than the query in ma code thanks aloot

[MMcCarthy]

here is how i am making a connection .
<%
Set RSANCR = Server.CreateObject("ADODB.Recordset")
connectionstr= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb")
strsql = "SELECT MacModle.Modles FROM MacModle WHERE MacModle.Cat = 'COPIER'"
RSANCR.Open strsql, connectionstr , 2
%>
the password is applied manually aon the access data base means by opening it through the file->open and then open exclusive ....it is not applied through any code all i want is that no one can open it else than the query in ma code thanks aloot

I'm not familiar with this connection string.

I will call on some of the other experts who may have more knowledge in this area.

[nico5038]

For the connection string syntax you can check:
http://www.connectionstrings.com/?carrier=access
of for 2007:
http://www.connectionstrings.com/?carrier=access2007

It will however reveal the password in your code....

Nic;o)

[NeoPa]

sir,
i am making an online appliation for submitting daily sales reports .i am using html dhtml asp and janvascript .the problem is if i apply password to the access database then it gives error "wrong password".what shud i do to secure ma database that it does not give any error while running any query in the program ,or while acessing the database,
thanks for help in advance

It's not very clear whether you want to rely on the operator to put in the password or alternatively, to give the password via the code. If the latter is required then you'll need to include it in the connection string.
Nico's post (#7) gives a link explaining how that can be done.

[ADezii]

here is how i am making a connection .
<%
Set RSANCR = Server.CreateObject("ADODB.Recordset")
connectionstr= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb")
strsql = "SELECT MacModle.Modles FROM MacModle WHERE MacModle.Cat = 'COPIER'"
RSANCR.Open strsql, connectionstr , 2
%>
the password is applied manually aon the access data base means by opening it through the file->open and then open exclusive ....it is not applied through any code all i want is that no one can open it else than the query in ma code thanks aloot

If your aim is to not allow anyone access to the Database while you are running your code, why not simply Open the Database with the /excl Command Line Option? (Exclusive).