Sorry if this is not the correct place to post this question. I am not looking for help in creating a database. I currently do not have access to Access. I used it for many years at my previous position about 7 years ago. Our IT department here using Crystal Reports for everything. The problem with this is that every database is completely controled by IT. I have a few databses built in Crystal Reports that I administer but even when I need a new report build I have to have our programmer make any of those changes. I work in the public sector where data collection is a very important part of our responsibilities. Currently there is so much data collection being done manually in either excel or even word. I would like to build a few databases in Access for staff to use that I would administer.

My problem is that I have just been told by a person I work with that the newer versions of Microsoft Access are vulnerable because some type of security has been removed from the newer versions and if more then 1 person is using a database that has been created that all users will be able to see and have access to everyone's information. So if I created a database that I wanted staff to use to update information, everyone that uses that database will be able to look at and access the information in the database of everyone else.

I am just wondering if anyone that is very knowledgeable with the newer versions of Access are familiar with this flaw and could share with me any solutions?

Thanks so much