ACCESS 2007 - preventing import or link; hidden objects
Posted on 2011-05-10
I am testing an ACCESS 2007 database which has a custom password (VBA code) system where depending in the password you are able to do certain procedures with the database (ie. FULL ACCESS = add/edit/view reports; PARTIAL ACCESS = only view reports). Tables and certain other objects are hidden and VBA code prevents an intruder from holding 'SHIFT' key to bypass password screen/system. However, I am finding that since some of the users share the ACCESS software on a server, if an intruder would turn on the viewing of hidden objects; he/she could import the tables/objects from the database that I am trying to protect.
Any ideas on how to prevent this??