ODBC - Tough one!

[mohsinhq]

i have approximately 100 users accessing a reporting system i have made in access which is linked to 5 databases.

i am trying to record in a table the user ID of a person who has added a record to the reporting system. The users connect to the linked databases through ODBC when prompted.

Any ideas on how i can store the username? or even show the username on the form?

Thanks in advance

 

[mohsinhq]

anyone have any sort of idea or area which i could research?

 

[mohsinhq]

(making link active again)

 

[sonny]

I'm assuming you on a LAN?....

You can get the users NetWorkID of the person opening your db.

I do this with my db and I compare the ID's with an employee table when the user attempts to preform certain things.

Now, with that said, I use a non visible unbound textbox to do this. I believe that if you create a append qry and trigger it when then form is updated, you could throw the value of the texbox into a table and include a date and time.

 

[WayneRyan]

From the Sample Database Forum:

http://www.access-programmers.co.uk/forums/showthread.php?t=62146

Wayne

 

[mohsinhq]

thanks to both of you! much appreciated guys