Forum home » Delegate support and help forum » Microsoft Access Training and help » Restricting Access
|
|
|
The UK's most regular 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. |
Restricting Access
Resolved · Low Priority · Version 2003
Reply Mon 14 Apr 2008, 16:49Delegate Nichole said...
Nichole has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Restricting Access
If you were to create a Personnel database with Access and restrict editing power (by putting it in a private drive) are you able to publish forms linked to the database on a staff intranet, so that when staff fill out their details they are automatically put into the database? So that i can gather their data in one place, but they can't see other people's records....?
For upcoming training course dates see: Pricing & availability
RE: Restricting Access
Hi Nichole, Thank you for your question, welcome to the forum, this is a good question for your starter; In your case what I would do is create a form which is a data entry only form, Form Properties and select Yes against Data Entry, then create a Data Access Page based on the Form, post the Data Access page to your Intranet with a link back to your underlying database, your staff will be able to use the form and save their data to your table, however they will not be able to see other than their own data (whilst they are entering it) I hope that helps, best regards Pete
|