How do i secure Access databases across versions?
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hmmm, I didn't think it would be this complicated. I thought that I could limit user's access to the database via AD/folder permissions. But I need to make the data "read only" so they can look at it and manipulate it but not change it. For some reason, I thought Access had features that allowed that. I was thinking along the lines of form permissions/settings? Am I completely off base?
I have MS SQL Server 2000 that I could store the data in, but I'd still need a front-end for it.
I have MS SQL Server 2000 that I could store the data in, but I'd still need a front-end for it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Alright, I'm going to close this question and open an new one leaving out the "versions" issue.
Thank you all.
Thank you all.
ASKER
The reason I don't think Windows/AD security will work for me is because I have to limit what the people who access the database can do with it (i.e. not change any data), so folder permissions aren't going to do the trick.