Access Rows and user security

[ADB1]

All,

I have an access database with some security on it. How would I have a column on a table that automatically has the username of the user that entered that row into the table?

Basically, any data entered into the database can be tracked against different user id's. Also how woudl I have a date stamp against a row so you can see when the data was written?

Ta.

A.

 

[PHV]

Create 3 new fields in the table (user,date created, date modified)
In the BeforeUpdate event procedure of the data entry form:
If Me.NewRecord Then
Me![date created control] = Now
End If
Me![date modified control] = Now
Me![user control] = CurrentUser

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ADB1]

Thanks PHV i'll give it a try. I'll also no doubt have more questions in a bit!!

A.