Retrieve network user name and insert into record

[rob]

Hello all,

I created a database that logs the status of multiple projects. The DB is
on the LAN at work and can be accessed by all.

The problem I have is it's too easy for folks with limited integrity to
change the status of a project (dates, % complete, etc).

I would like to lock the database down (easy) and simplify the updating
process and at the same time, limit the users access/ability to change data
in the tables/queries.

What I would like to do is when a user adds an entry, a timestamp (easy)
and MS 2000 user name is automatically entered into a username field.

Does anyone know how to add a network username inot a record
programmatically?

Rob

 

[Jeff Conrad]

You'll find code to retrieve the network user name here:

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

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[rob]

WOW! Way too easy!

I need to leave Management and return to coding because my skills are
diminishing at an exponential rate!

Thanks for the assist!



Rob F

 

[Jeff Conrad]

You're welcome, good luck with your project.