I have a Microsoft Access database that I will be emailing to various people for data entry only. Is there and easy way to lock/password certain tables, queries, reports, forms, macros from being modified in design or entries add/changed to a specific table. The database pops up with the current form for them to add info., but in the past some have changed certain tables and added info. I want to prevent this.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Security Question
- Thread starter rsims
- Start date
Read all you can about user security and adding security using the security wizard in the help files. This is non-trivial and does not lend itself to an easy explanation. I have quite a few applications that are 'secured' according to Microsoft. There are some gotchas associated with this.
Steve King Growth follows a healthy professional curiosity
Steve King Growth follows a healthy professional curiosity
- Status
Similar threads
- Locked
- Question
- Question