Starting with Access 2003, Microsoft installed macro security settings. These settings can often inhibit use of the Access database. One of the most common warnings folks recieve upon opening a newly installed Access database is a macro security warning. The user may get a pop-up notification that a macro action "cannot be run in disabled mode". Or the user may see the following yellow bar across the top of the database screen:
Content can be enabled manually, every time the database is opened. Or, it can be enabled permanently through the Microsoft Trust settings.
One common question from folks about their Access databases is: "Can my Access Database be programmed to pick up the logged in user? The short answer to this question is, "YES". Details follow:
For more information about building user management into your Access database, Email Michelle with your questions.