patrickv
Active Member
I've just finish working on a database.Now i want one thing.i need to set security on it so that the person making data entry wont mess around with the tables and lookups. below is the DB and how i want security
Tables:
Contact Lookup - access deny
Main table - access deny
Training Record - access deny
Forms
Data entry Form - Form use by the user for entry info
Training record subform - access deny
so basically if let's say. Patrickv tries opening Main table , he will get access deny.ANY IDEAS HOW TO CARRY THIS OUT
PS
n the machine where this will be use there's Administrator and a standard user.Only standard user will work on this
Tables:
Contact Lookup - access deny
Main table - access deny
Training Record - access deny
Forms
Data entry Form - Form use by the user for entry info
Training record subform - access deny
so basically if let's say. Patrickv tries opening Main table , he will get access deny.ANY IDEAS HOW TO CARRY THIS OUT
PS
n the machine where this will be use there's Administrator and a standard user.Only standard user will work on this