Let me start out by saying that I am not the least bit concerned with securing my database. However, because user profiles are a part of security (or at least that is the extent of my limited understanding of them) I am posting in this subform.
All I want is for access to recognize the name of the person who is currently using the database. The reason is that I have a memo section that is used for storing notes made by the user. Each entry is stamped with VBA code as follows:
Code:
Me.Memo = Me.Memo.Value & vbCrLf & CurrentUser() & ": " & Me.Text145.Value & " - at " & Now() & " : "
Thus, I just want the memo section to properly identify the person - or currentuser() - leaving notes.
I have created a basic login screen using this. If only I could somehow tell VBA to recognize the name of the person who has logged on...