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....?
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
