By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

database security issue

omerbutt
100+
P: 638
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
May 8 '07 #1
Share this Question
Share on Google+
8 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
You have posted in the Articles section. I am moving this question to the Access forum.

ADMIN
May 8 '07 #2

omerbutt
100+
P: 638
You have posted in the Articles section. I am moving this question to the Access forum.

ADMIN
thanks ...
do give an answere too
May 8 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
May 8 '07 #4

omerbutt
100+
P: 638
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
May 8 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
May 8 '07 #6

nico5038
Expert 2.5K+
P: 3,072
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)
May 8 '07 #7

NeoPa
Expert Mod 15k+
P: 31,342
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.
May 8 '07 #8

ADezii
Expert 5K+
P: 8,619
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).
May 8 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.