Can 2 users access a password protected front-end ?

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

There is a request that to get a front-end password protected. The
front-end is used by 2 end users.

I just wonder if user A get the front end database password protected
(Tools --> Security --> Password Protected), can user B access the front-end
when user A is using ?

If not, what is the best way to make sure that both User A and User B has to
enter password before accessing the front-end database ?

Thanks
 
Run the FE locally on each machine, the one user will not have any bearing on
the login of the other. That is assuming you are using a split Db.

regards,
Nick.
 
Dear Nick,

It is a pretty good idea.

BTW, does it mean that a password protected database cannot be used by 2
users simultaneously ?

Thanks
Peter
 
On the contrary. Using a split Db all users can have access to the data
simultaneuosly regardless of password protection.
Personally, I don't use the built-in security because it is too easily
cracked and my applications tend to run on a MySQL backend as my clients
typically want WAN access once they know it is possible. (Access does not
like running over WAN). I have developed my own security which works in with
the MySQL security. Having said that, I have never had an issue with multiple
users having password on applications before I moved to MySQL backends.

Regards,
Nick.
 
Back
Top