Protect Audit Table

[sun_after_rain]

Hello!

I have an audit table. Does anyone have any suggestions on how to protect the table from being tampered with?

Thanks!

 

[boblarson]

with Access there are no guaranteed ways to do that. You can try hiding it but that is only as good as nobody knowing to look, which isn't secure.

If you must have secure data, then it is better to use SQL Server or SQL Server Express as the backend, so you can use Active Directory groups, or SQL Server groups to grant specific permissions.

 

[sun_after_rain]

Is there any way to lock the fields? I don't want to protect the fields from being changed.

 

[Johnny Drama]

You do or you don't want to protect the fields. And is it the field you want to protect or the data in the field?

 

[boblarson]

Is there any way to lock the fields? I don't want to protect the fields from being changed.

There is no way to lock or protect the fields from being changed at the table level. If you need that functionality you would need to change to SQL Server/SQL Server Express.

However, if the users are kept to using forms and have no access to the tables then you can use the form's On Current event to lock anything that has data by using:

Me.AllowEdits = Not Me.NewRecord