Password protected backend problem

[Chris]

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

[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.

[Chris]

Perhaps what?

[dgs5150]

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.

[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.