Hey Guys -
So I have a database where on open, it determines who the user is and what level of access they have. If they are not listed as an "Admin" in the database, it removes the ability to view tables and basically locks down the database.
It works great! It even disables the bypass key (SHIFT) so sneaky users cannot change things.
Heres my problem... because it is an AutoExec macro, if the user turns off macros, it completely skips all of this and opens up an un-locked database! I have no idea how to fix this...:banghead:
any thoughts?
So I have a database where on open, it determines who the user is and what level of access they have. If they are not listed as an "Admin" in the database, it removes the ability to view tables and basically locks down the database.
It works great! It even disables the bypass key (SHIFT) so sneaky users cannot change things.
Heres my problem... because it is an AutoExec macro, if the user turns off macros, it completely skips all of this and opens up an un-locked database! I have no idea how to fix this...:banghead:
any thoughts?