D
Dave Elliott
If users have to be able to access this folder, then how can I protect the
back end db?
back end db?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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
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
R
Rick Brandt
Dave Elliott said: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.
T
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
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