working with userid in access multiuser environmnet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,

Every user in the multiuser application i created has a unique userid.
After the login, the user creates some specific entries. A list of all these
entries is presented to every active user in the rest of the network. I want
the user id to be shown next to each entry, to control who inserted what.

I don't know if this helps but the database is not in an SQL server and the
database is not split.

I would appreciate any help or hint
Thanks in advance
 
kastoras said:
I want
the user id to be shown next to each entry, to control who inserted what.
Click to expand...

In the form's before update event use code here:

http://www.mvps.org/access/api/api0008.htm

and store the value in a ModifiedBy column of the table. When you run
queries, the last person to modify the record will be listed in the
ModifiedBy column.
the
database is not split.
Click to expand...

Since it's a multiuser application you'd better split it, sooner rather than
later.
 
Back
Top