Access Security Question

[Squint]

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

[ItsMe]

You are probably refering to user groups and permissions that are no longer available in newer versions. If that level of security is enough, you can probably do just as good using Active Directy to secure the tables on a back end file and use code to restrict access to a front end file.

If you need higher security than that, then you need something like SQL server to secure the tables. You can still use Access to retrieve data from SQL server.

[ssanfu]

As ItsMe said, the user security was removed in A2007. The reason was that the security was fairly easy to break.

There is a "Get User Automatically and Security Level example " database written by pkstormy that adds some security by user level.
It is something you have to test to see if it meats your requirements.

See: https://www.accessforums.net/code-re...mple-7538.html

Access security is a large subject....

[NTC]

It is true that the embedded User Group Security feature of Access thru the .mdb era is now gone.

It is not true 'that all users will be able to see and have access to everyone's information'. The developer must:
* set up log in, and manage data visibility by log in
* make an accde version of the front end so bypass to tables/design is not possible
* encrypt the back end data file (a standard feature in the product)

One final comment - is that you post that you are proposing to move to Access databases for information that is currently being handled in Word/Excel. So the security features of those products really is the comparison point - and by which Access compares favorably.