How can i catpure a user login ID so i know who edited the db?

[spawn21]

help me. i'm trying to cature a user login so i know who updated or edited the db .

[MMcCarthy]

help me. i'm trying to cature a user login so i know who updated or edited the db .

This depends on your login procedure. You will have to give a lot more information.

[ADezii]

help me. i'm trying to cature a user login so i know who updated or edited the db .

'Based on the assumption that you have multiple Logins, you can maintain a
'simple history of who logged into your Database at which times simply by:

Private Sub Form_Open(Cancel As Integer)
  Open "C:\Log.txt" For Append As #1
  Print #1, CurrentUser() & " logged on " & Date & " @ "; Format$(Now(), "hh:mm AM/PM")
  Close #1
End Sub

Output would be: Admin logged on 12/12/2006 @ 10:20 PM

[NeoPa]

It's not clear exactly what you're after, but if you want the name the user logged into the PC as - then you could try

Environ("UserName")

which should return that value for you.

[MMcCarthy]

ADezii

A little off topic but I was wondering if you could set up your PM facility. It would make it easier to contact you when I have questions I can't answer I like to let the forum experts know so they can take a look.

Mary

[ADezii]

ADezii

A little off topic but I was wondering if you could set up your PM facility. It would make it easier to contact you when I have questions I can't answer I like to let the forum experts know so they can take a look.

Mary

Mary:
I would be more than happy to set up my PM facility as soon as I know exactly what this is and how to set it up. Sorry for the ignorance on my part.
Looking forward to hear from you soon.

[MMcCarthy]

Mary:
I would be more than happy to set up my PM facility as soon as I know exactly what this is and how to set it up. Sorry for the ignorance on my part.
Looking forward to hear from you soon.

Hi ADezii

On the top right of your screen there should be a welcome message as follows:


Welcome, ADezii. | 0 PMs | Control Panel | Buddy List | Log Out


The first link on mine says 0 PMs yours may be slightly different as you haven't set it up yet. When you open it you should be given a set up procedure. Let me know if you've any problems.

Mary

[NeoPa]

At the top click on 'Control Panel'.
At the left click on 'Edit Options' under 'Settings & Options'.
Under the 'Messaging & Notification' block tick each of the three boxes.
Go to the bottom and Save Changes.

BTW this means that the MaryBot has noticed you - Congratulations.