Access CurrentUser Function: Are There Any Benefits Here?

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’.access currentuser

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?”

Access Macros 2010: How To Use Data Table Macro Triggers

Access Macros 2010: How To Use Data Table Macro Triggers

If you are currently using Microsoft Access 2010, you will probably have seen the new data Access Macros 2010 for a table which there are 5 different events to choose from.

Take a look at this video tutorial (which is less than 5 minutes) demonstrating how you can set and apply a data macro to a table and in this case using the ‘Before Change’ event.

httpv://www.youtube.com/watch?v=06Uh-z2kS3I

Access Macros 2010: How To Use Data Table Macro Triggers

There are therefore three types of macros available to this version making Continue reading “Access Macros 2010: How To Use Data Table Macro Triggers”