checking username

[VilMarci]

Hi,

I'd like to allow employees to access and update their own data in an Access
database.
Is there any way to retreive the username they use for login with Visual
Basic (or function)?
Here's the story:

User logs in with NT userID & PW as ususal
Launches the .mdb from a shared folder
A script checks the userID (somehow) and opens a form in edit mode filtered
by the userID.

Thanks for your help in advance

VilMarci

 

[Steve Schapel]

VilMarci,

This can't be done with a macro, as far as I know. However, there is a
VBA funnction at http://www.mvps.org/access/api/api0008.htm which will
do the trick.