Security/Protection of Information

[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

 

[Scott McDaniel]

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.