View Last user on database

[Guest]

hello, I am trying to have an unbound text that shows the admin who was the
last person on the database. I have this module that checks the user ID on
the network. I want to somehow incorporate that user Id, saying that this
person was the last person on teh database and @ this time. PLease help

 

[Rick B]

You would need to store that value somewhere. Put is in a table, or change
the value of some control on a form.

 

[Guest]

ok, what do you mean change the value of some control

 

[Rick B]

If you have some unbound field on a form somewhere, you could use vb code to
change it. Not sure I would go this route.

 

[Guest]

ok, so please help, what way would u take this.
I just want something to show the users, on the main menu that this user
+date/time was the last person on the database

also, if there is a way to show who the current users are @ the same time

 

[Rick B]

I don't know exactly how to go about it.You would need to write code that
stores the current user in a field in a table. You could also write the
date and time. What exactly are you trying to accomplish? Why would you
care who used it last? Also, when you say last, do you mean that you want
to store the name/time/date when they LEAVE the database file or when they
OPEN it? In either case, youd have to write the data to a table.

I would think that timestamping changes to specific records might be of more
use. That is pretty easy to do.

As fare as seeing who is in a database at a particular time, there are tools
out there to do that. You could do a search in google.com using the
"groups" section to find previous posts that talk about how to determine who
is in a database. I'd use the following search string...

microsoft.public.access ldb viewer