I downloded this sample DB designed by "Sullitec" But i have two problems:
- In the table "ztblUserLog", how is the SecurityID dropped into it when a new user logs in? Which is the VBA passed on the form to enable such update on the table?
- Suppose for each sales operation on the Table "tblSales" you wish to know who entered the record. For that reason, on the the "tblSales"you create a field for "SecurityID", How will it be possible for that field to be updated with the securityID of the the user who entered the record, knowing that it is a multiuser DB and Many people are loged in at that time. (Assume the "user" uses the form "frmSales" to perform the opertion)
Security Levels 2012.zip
I will be glad receiving help from anyone