How do i secure Access databases across versions?
Posted on 2011-02-24
I have 2 new MS Access databases that I created using Access 2010.
1. I need to make 1 of them available to users who may be using versions anywhere from 2000 to 2010. They need to be able to view the information and manipulate it, as in searches and filters and sorting, but not be able to add, delete. or modify any information. I have to be able to add, edit and modify.
2. The 2nd database needs the same restrictions as the first but should only be viewable by a select group of people.
Any ideas on how I could secure these databases? Do I need to limit the Access versions that people will be able to use?
Thanks in advance!