Security

[mike30x]

Is it possible to record who updates/changes/adds infromation on a database. I will have multiple users logging onto the DB to add another extra element of security can people lock there infromation by password after it is entered much the same as a digital signaure in PDF forms.

 

[neileg]

There is nothing in Access that does this by default. Do a search in these forums for 'audit trail' to see how this can be implemented.

 

[GuidoNTS]

You can do it by creating e new table in which you put the fileds "NameUser", "Date", "Action", ...
On each form you, after each entry in a field, you put these actions in that table
I do it as follow:
set rs = currentdb.openrecordset("Table")
rs.addnew
rs("NameUser") = UserName
rs("Date") = Now() ' time the action took place
rs("Action") = The content of the changed field
rs.close

You can, of course, add other fields to your table