How Can i Protect Back End

[Dave Elliott]

If users have to be able to access this folder, then how can I protect the
back end db?

 

[Dave Jones]

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

 

[Rick Brandt]

If users have to be able to access this folder, then how can I protect the
back end db?

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.

 

[TC]

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