I have an Access 2003 DB Front-end with MS SQL 2005 Back-end. Some of our shop users login to their PCs using a common "Shop" account. They also have a "Personal" account for accessing MS Exchange e-mail using OWA so do have a personal AD account.
When these users open Access I wish them to "Login" using their normal AD Username & Password.
Any hints/code how I can achieve this?