restrict database access and allow only userform

[isurunk]

how to allow access to a particular user to userform only to enter data but restricting the access to database they are updating so that data is secure. another high level user may have all permission to access database for data analysis.

[Bulzie]

Few ways to do this I am sure. I usually have a Login screen with ID and Pasword, I check the ID/password against Active Directory to make sure they are an employee, then check the ID against a Users table to make sure they have access to get into the specific database. Also in Users table I have a Group field that lists Admin, Edit, ReadOnly, etc. and depending on which group they are in I disable or hide forms, other stuff, etc.

[June7]

I do similar but not really for security, just to identify user for documenting in records. Because securing an Access database really is quite difficult. Anyone with minimal computer savvy can get by most 'security' settings in Access, the shift key bypass on an accdb is the first technique for that. Then if they know where the backend is located they can go there and do whatever.

Code behind my main menu form will manage display of some command buttons depending on permissions in Users table as well as customize the ribbon.