Database

T

taborp

I have created a new database with one primary table, and several small
tables that contain values for drop down lists used in the primary table. is
there a way to set permissions so that users can edit the primary table, but
not edit the other tables? Also, is there a way to add a field in the
primary table that will automatically record the user name and date of the
last person to edit the records? This way, we could keep track of who made
the last change if there is a problem with what was entered.
 
D

Douglas J Steele

The only way to control who can update what is through Access Security.

If you want to go that route, start at
http://support.microsoft.com/support/access/content/secfaq.asp

Read the article thoroughly several times, and work on a copy of your
database. Do not skip any steps!

As for the second question, you cannot do that if the updates are being made
directly to the table, but it's fairly easy to do in a form. Have fields
showing last updated and last updated by (they can be hidden), then put
logic in the form's BeforeUpdate event to populate those fields. Since users
should never be updating tables directly, this shouldn't be a limitation...
 
Top