Run-Time - Multiple users

  • Thread starter Steve via AccessMonster.com
  • Start date
S

Steve via AccessMonster.com

I have run-time installed in my user's local hard drives - I have 20+ users
performing data input and editing - how can I set it up so an individual
users input can be ID'd. I would like to do something like have a field in
my source table on the back-end called "LastModBy" with some way of uniquely
identifying which user input or updated the record?
 
G

Gijs Beukenoot

Steve via AccessMonster.com was zeer hard aan het denken :
I have run-time installed in my user's local hard drives - I have 20+ users
performing data input and editing - how can I set it up so an individual
users input can be ID'd. I would like to do something like have a field in
my source table on the back-end called "LastModBy" with some way of uniquely
identifying which user input or updated the record?
Click to expand...

Well, exactly like you say. Create that field in the table and and on
the form. On the beforeupdate, set the value to the username. You can
retrieve the username with the GetUserName function (example on
http://c85.cemi.rssi.ru/Access/Queries/TipDetail.asp?TipID=12 )

Although it micht be better to store the username in a separate table
and link to that table with the ID field since such a field would
increase eacht record with, well, as an example, something like 20
characters...
 
Top