FrontEnd BackEnd Security.

[Ryath]

Hi all,

I've finally finsihed my company database and its quite huge with about 30 queries, 10 reports, 7 forms modules etcetc... since this database will be used by about 30+ employees its gonna need to be efficient as possible specially that its already taking AGES to load even with 3 users logged in!!! The security is already set up on a user level basis, so that you need to log in with the right user and pass. Now i think to speed things up i would need to split it (Front End Back End) the problem is that the back end is not protected??? i have 3 user requirements Admin, Full data inputting , and Readonly. If i set user level on the back end will this confuse things even more?? and i would have to log in twice?? how can i protect the back end?? with the 3 user levels? or make it protected in accordance to the current log in status of the front end??

Thx all

Will

 

[Ryath]

Ok i'll try and explin it breifly the back end can be opened manually with no protection!! ie no username or password but its set on the front end!! how can i protect the backend?

Will

 

[jebry]

Hi!

In a module in the backend put this code in a public function:

If CurrentUser <> &quot;yourLANname&quot; Then
DoCmd.Quit
End If

Then create a macro called autoexec and use the action RunCode with the name the function you just created. Now you will be the only one who can open the back end.

hth
Jeff Bridgham
bridgham@purdue.edu