I have an application that has a frontend Access database that contains some forms, and a backend Access database that contains tables which the forms update. In the backend, there is a 'user' table that lists user-ids and their security level, either 'admin' or 'user'. The frontend database links to tables in the backend. Upon opening the frontend (shift bypass is disabled), an 'autoexec' macro checks the security level for the user. If the user passes this check, the form opens and the user begins data entry.
My question is this. How do I prevent the user from causing a '2001' error and stopping all macros, thereby gaining access to all database objects, by simply copying the database to an 'untrusted' location?
My question is this. How do I prevent the user from causing a '2001' error and stopping all macros, thereby gaining access to all database objects, by simply copying the database to an 'untrusted' location?