Username

[Svein]

Hi,

I have an mdb database where I would save myself a lot of trouble if I could
retrieve the username I logged into the database with, in an SQL statement.
I would like to use the username as a filter at record level in some
queries. Any suggestions?

Secondly, is there a Jet engine function library reference anywhere where
all functions that I can use in an MS Access SQL statement are listed?

Thank you,

Svein

 

[Rick B]

=CurrentUser()

will return the Username that was entered when the database was opened.

 

[TC]

Do a google web search for "jet sql reference", there are lots of hits.

HTH,
TC