Bacon Bits:

When developing your Excel or Access application, it’s not uncommon to need to capture your user’s domain/username for one reason or another. A user’s domain/username combination is the traditional unique identifier for a user - often captured by programmers to do things in like:

• Help manage user login and permissions
• Create a history of who used the application
• Capture the name of each user who made the changes to data
• Personalize outputs and program messages for users

.
There are literally half a dozen ways to capture a user’s domain name and user name. In this post, I’ll give you a very easy method using the Environ function.

. » More: Capture a User’s Domain\UserName

I’m fresh from the DataPig Power Analyst Bootcamp.  As usual, it was a blast.  I’d like to give a shout out to Earl who taught me more than I really need to know about the chicken breeding business (he works for a company called Aviagen).

 

Anyway, during the bootcamp, someone asked how they can work windows authentication into their Excel or Access application.  It just so happens that I have a hack for that!

  » More: Use Windows Authentication for your Excel and Access Applications