Security/Protection of Information

  • Thread starter Thread starter jwrnana
  • Start date Start date
J

jwrnana

Is there a way to track any changes made to my database? There will be
several other people working with the same information and I want to be able
to see what changes have been made to the records.

Is there a way to prevent anyone from changing the information once entered?

Please answer as separate questions as I may need to do only one of the
above.

Thanking you in advance. Joy Rose
 
Allen Browne has good information regardit audit logging:

http://users.bigpond.net.au/abrowne1/AppAudit.html

There are several Form properties you can look at to achieve your second
goal. You can set AllowEdits = False, and this should work. Form's have a
DataEntry property which, when set to True allows users to add new records
only. These properties are available in Design view, from the Data tab of
the Properties dialog.
 
Back
Top