Link to home
Start Free TrialLog in
Avatar of DowneyCity
DowneyCityFlag for United States of America

asked on

Access security to an old access program

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.

Thanks
SOLUTION
Avatar of pdebaets
pdebaets
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DowneyCity

ASKER

The two first ones are what we plan on doing in the future.  The last one will help out for now.

Thanks