Secure back end

[klasse]

Hi,

I have a database consisting on the back end and the front end.
It will be placed on a network (NT) drive.
I want to disable people accessing the back end. The only access to it should be through the front end.

Any ideas on how to do it?

Thanx!

Klasse

 

[jebry]

Hi Klasse!

Try this function:

Public Function BESecurity()

If CurrentUser() <> &quot;YourLANName&quot; Then
DoCmd.Quit
End If

Now make an autoexec macro using the RunCode action and select this function to run. Disable the shift key and you are set. No one except you will be able to open the database.

Another thought would be to go to the database properties by right clicking on it in Window's Explorer. Then select the hidden check box. Now no one will be able to see the database, even if they try to import from another database.

hth Jeff Bridgham
bridgham@purdue.edu

 

[klasse]

Hello jebry,

Good one, it works fine. I had the doubt if it would not then allow people to connect to the it from the front end, but it works!

Thanks,

Klasse