We are upgrading a database from MDB to ACCDB format. As such, workgroup security is no longer available.
I need to restrict use of the database. Specific reports/forms are executed by a macro that's linked to a button on a form (menu).
How can I leverage Active Directory groups inside the ACCDB database to control the security? Specifically, how can I script the macro to evaluate the active user's security and determine if they can/can't be let in?