I am trying to figure a way to flag which use is entering/editing data
into a multi user database. The OS is XP, and each user logs on with
their own network password.

Any help on this, especially how to get the users ID into the database
automatically, would be greatly appreciated.

Thank you,

ShyGuy

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Depends:
If you have a JET db with user security then you can use the CurrentUser
function to get the user's name/signon.
If you're using MS SQL Server you can use the current_user() function to
get the user's network signon.

You can design the table to have a column value that defaults to either
of these function's result. E.g., a JET db table design view:

Default Value: =CurrentUser()

Same in MS SQL Server, except use CURRENT_USER() w/o the equal sign.

HTH,
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBPzAL24echKqOuFEgEQLDbACeIW1hpFVAXaZjImir3YgYO5 CI/ZAAoOFh
aUcHZEfvj1ifzDOQSbou+Ht0
=O7E/
-----END PGP SIGNATURE-----


Shyguy wrote: