If security is that important then you need to move to SQL database. But if
your on a budget use access as a index to other files. Store file names and
keep the data outside of access in individual password protected documents.
But to answer your question
http://www.mvps.org/access/api/api0008.htm
will get you the logon name.
"SF" <xyz@yahoo.com> wrote in message
news:OTVGlIS7IHA.1592@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I was assign to develop an Admin Forms database for my office. It consists
> of 20 or more form. Our HR personel adviced us not to allow browsing staff
> information. Is there a way to capture login name of the current user from
> AD? I want to bing this login name to the name of staff sothat staff who
> uses the form can only select their own name (I want to restirct this
> because if user can browse other staff name he/she can see the remaining
> balance of the medical allowance, education of the other.).
>
> TIA
>
> SF
>