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