Restricting Access

Resolved · Low Priority · Version 2003

Mon 14 Apr 2008, 16:49 Delegate 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....?

Mon 14 Apr 2008, 19:20 Trainer Pete said...

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

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Restricting Access

Restricting Access

RE: Restricting Access

Access articles

Access tip:

Splittng a database