getting system time...

[calvinho]

i want to get the system time of the machine
where the access database resides, when i
retrieve a record from that database on
another computer. it makes sense since i
have to make the user can access the
resources for a definite period of time,
with reference to the system time of one
machine, ie. the one with the database.
should a add an additional field in the
table, or just write some code in vb in
order to accomplish the task? thank you for your attention.

[Mik]

How come you want to limit the time each person can open the DB? With an AccessDB you can have multiple users use the db (up to 20 with no probs I think)... If you have more than that have the DB be a "Snapshot" type.

I can't think of a way to grab the systime of another computer but you could use the VB timer event. OR add a table to the DB to write user's access-times and check up on the times that way!


------------------
(\/) | |<
www.yesic.com/~mik

[calvinho]

i wanna to limit the access-time since there'r limited numbers of computers available to the users, so that each of the user is offered to use for a session.
regarding to ur second suggestion, how can i write their access-time? r there any functions to do it?
another question is that is it possible to allow up to 40 users to access the database simultaneously? if so, would you guide me the way? thank you =)