Back end security

[Cardinal]

I have split a database and placed the back end tables up on a shared
drive. Is there a way that I can protect the data from prying eyes? I
tried password protecting the Back end database but then it could not
be accessed by the mde files that I will be distributing to the end
users. I am using MS Access 2003. Thank you.

 

[Damon Heron]

There are various levels of security to the b/e tables, but if someone is
really determined there is not
much you can do except make regular backups. I use a simple logon form in
the backend (set as startup form)
and have a big stop sign cmdbutton that closes the db) on it that scares
away most users, with a logon password that will allow access
to the backend by those in the know. You also may want to disable the
shiftkey access with :

CurrentDb.Properties("AllowBypassKey") = False

Damon

 

[Dorian]

You can set folder permissions on the folder where the back end resides.

-Dorian