Access CurrentUser Function: Are There Any Benefits Here?
Some of my students during a training session recently discovered the Access CurrentUser function listed from the Expression Builder tool which is one of the predefined members of the MS Access ‘built-in functions’ category and assumed it would return the currently logged on user (via a network) but in all cases it showed as ‘Admin’.
So why bother using this function at all? Well, it’s really a legacy function from the throwback to the earlier format ‘MDB’ files which used the Workgroup Security utility (and has now been dropped with the later ‘ACCDB’ versions).
Also, every time you started your Access database, the system generates a same named locking file (ldb/laccdb) which stored one or more of the machine’s name (multi-users) but not the actual user so this is really not the same thing. So how do you Continue reading “Access CurrentUser Function: Are There Any Benefits Here?”