How Can i Protect Back End

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

If users have to be able to access this folder, then how can I protect the
back end db?
 
I use the AutoExec macro to run a function named start in
a module.
The code for the function is:

Function Start()
Dim Strinput
Strinput = InputBox("If you have an administrator password
please enter it. If not please click
Cancel", "Administrator Password")
If Strinput = "your password goes here" Then
'Do nothing
Else
Application.Quit
End If

If the user does not enter the correct password, Access
quits immediately.

Dave




End Function
 
Dave Elliott said:
If users have to be able to access this folder, then how can I protect the
back end db?
Click to expand...

You can use Access security, you can obfuscate where the data file is, and you
can make lots of backups. There is only so much you can do with a file-based
database.
 
But with that solution a user can just create a new db & link to the tables
in the (still unprotected) BE.

The proper solution (IMO) is user-level security and Run With Owner
Permission (RWOP) queries - not a task for the faint hearted!

TC
 
Back
Top