Access security to an old access program
Posted on 2011-09-29
The city would like to give access to different Access programs to the police department with restrictions on what data and tables they can see (no social security numbers). The security set up on the access database was done with out the access security. Basically anyone with any knowledge could access our data if the want to. At this time we do not want to rewrite the security of the access database, but would like to be able to run a script to copy what tables and data the police department can see. This also is between two different servers and firewalls.