Back end security

  • Thread starter Thread starter Cardinal
  • Start date Start date
C

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.
 
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
 
Back
Top