Splitting a database with a password

[Duane]

I have a database where I opened it exclusively and set a password for it.
I used the database splitter wizard to split the database, which worked
fine. The wizard split the database and the password is still required to
open up the frontend, however, there is not a password on the backend where
it is actually wanted and needed.

I opened up the backend exclusively and set the same password on the backend
as is on the frontend. I open the frontend using my password, but where i
open a form I receive an error message stating "Not a valid password". Is
there a way to progam the connection to the backend so the passord is valid?
Or do I need to look for another solution for protecting the backend.

I like using the password protection in access verses setting a password in
VBA because with VBA password protection you can just create a new database
and import all the object into the new database and have access to all the
data, but with the security in access, that is not "quite" as easy to do.

 

[Bob Quintal]

I have a database where I opened it exclusively and set a password
for it. I used the database splitter wizard to split the database,
which worked fine. The wizard split the database and the password
is still required to open up the frontend, however, there is not a
password on the backend where it is actually wanted and needed.

I opened up the backend exclusively and set the same password on
the backend as is on the frontend. I open the frontend using my
password, but where i open a form I receive an error message
stating "Not a valid password". Is there a way to progam the
connection to the backend so the passord is valid? Or do I need to
look for another solution for protecting the backend.

I like using the password protection in access verses setting a
password in VBA because with VBA password protection you can just
create a new database and import all the object into the new
database and have access to all the data, but with the security in
access, that is not "quite" as easy to do.

After setting the password in the back end, you must use the Tools->
Database Utilities->Linked Database Manager to set the password on
the back end. That password can be different from the one on the
front end.

 

[Duane]

Thanks Bob. I was finally able to get it to work. For some reason I had
to delete my links to the back-end and then re-create them. Once I did
that, it worked great.