98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access protection
Access protection
Resolved · Low Priority · Version 2003
Wed 4 Jun 2008, 09:09Delegate Kevin said...
Kevin has attended:
Access Intermediate course
Access protection
Can you protect a table in Access from certain users, so they can't change the data?
Wed 4 Jun 2008, 10:50Trainer Carlos said...
RE: Access protection
Hi Kevin
The way to protect a table from having the data changed by certain users is to set up user level security, so that all users need a password to access the database
Then you can set which objects the users can access and whether they can make changes.
Alternatively you can hide all the tables and have the users access them by clicking buttons on forms.
These buttons could run Macros that open the table as Read Only
Hope this helps
Carlos
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Using the Quick Access Toolbar in Access 2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
