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

Password protected backend problem

P: n/a
I have a frontend that has some tables which are linked to a backend.
Now I want to make the backend password protected and when I try to
run it password protected I can't open it. In the first form that
opens in the front end, I added the following to the form_open event:

Dim cnn As ADODB.connection

Set cnn = New ADODB.connection
cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Properties("Data Source") = "C:\backend.mdb"
cnn.Properties("Jet OLEDB:Database Password") = "password"
cnn.Open
Set cnn = Nothing

It seems like it is running the code but not opening up the links or
not keeping the connection open. After I run this code and I click on
one of the linked tables I get the message "Not a valid password". How
can I get it to work as if there was no password on the backend?

Thanx,
Chris
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
CDB
Perhaps?
"Chris" <ch*******@hotmail.com> wrote in message
news:cf**************************@posting.google.c om...
I have a frontend that has some tables which are linked to a backend.
Now I want to make the backend password protected and when I try to
run it password protected I can't open it. In the first form that
opens in the front end, I added the following to the form_open event:

Dim cnn As ADODB.connection
.... Set cnn = Nothing

It seems like it is running the code but not opening up the links or
not keeping the connection open.

Nov 12 '05 #2

P: n/a
Perhaps what?
Nov 12 '05 #3

P: n/a
ch*******@hotmail.com (Chris) wrote in message news:<cf**************************@posting.google. com>...
Perhaps what?


Why password protect the BE? There are MANY utilities that will read
the access file and tell you the password. You cannot really protect
access if someone wants to open it. Password won't slow them down for
long.

An alternative I have used is to put in a procedure that presents a
warning form to the user, logs their Login Name (API) and the time
they attempted to open the backend. The form then has a timer which
closes the form and quits access. While this is not secure it
prevents a user from accidentally opening the file which is all you
can really do.
Nov 12 '05 #4

P: n/a
CDB
I have not yet seen chrisw's response asking "Perhaps what", so attach a
response here.

When cnn is set to nothing, the object is entirely destroyed - how could
anything of it then be seen?

Clive
"dgs5150" <dg*****@yahoo.com> wrote in message
news:52**************************@posting.google.c om...
ch*******@hotmail.com (Chris) wrote in message

news:<cf**************************@posting.google. com>...
Perhaps what?


Why password protect the BE? There are MANY utilities that will read
the access file and tell you the password. You cannot really protect
access if someone wants to open it. Password won't slow them down for
long.

An alternative I have used is to put in a procedure that presents a
warning form to the user, logs their Login Name (API) and the time
they attempted to open the backend. The form then has a timer which
closes the form and quits access. While this is not secure it
prevents a user from accidentally opening the file which is all you
can really do.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.