By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

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

P: 1
help me. i'm trying to cature a user login so i know who updated or edited the db .
Dec 12 '06 #1
Share this Question
Share on Google+
7 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Dec 12 '06 #2

ADezii
Expert 5K+
P: 8,669
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:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Open(Cancel As Integer)
  2.   Open "C:\Log.txt" For Append As #1
  3.   Print #1, CurrentUser() & " logged on " & Date & " @ "; Format$(Now(), "hh:mm AM/PM")
  4.   Close #1
  5. End Sub
Output would be: Admin logged on 12/12/2006 @ 10:20 PM
Dec 13 '06 #3

NeoPa
Expert Mod 15k+
P: 31,660
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
Expand|Select|Wrap|Line Numbers
  1. Environ("UserName")
which should return that value for you.
Dec 14 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 14 '06 #5

ADezii
Expert 5K+
P: 8,669
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.
Dec 14 '06 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 14 '06 #7

NeoPa
Expert Mod 15k+
P: 31,660
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.
Dec 14 '06 #8

Post your reply

Sign in to post your reply or Sign up for a free account.