Security

[greysquirl]

I am trying to ad some security to an Access database I have created. What I am looking for is something along the lines of an admin screen I can add in Access that will alow me to add/delete users and asign rights to users. If anyone knows where I could find information on this sort of thing I awould appreciate some help. Thank you

 

[JoeMiller]

Tools->Security Joe Miller
joe.miller@flotech.net

 

[greysquirl]

I have tried that and was not satisfied with Access' ability to secure my database. What I am looking for is something I can build within Access and add to my database.

 

[JoeMiller]

What were you not happy with?? Access security is VERY VERY thorough and very configurable. Often times people set it up improperly because they do not read the documentation fully. As for writing your own, it can be done, but it's pretty difficult to do effectively. There have been many posts on this topic in these forums, I suggest you use the keyword search facilities.

Joe Miller
joe.miller@flotech.net

 

[greysquirl]

I think the biggest dislike to the security that Access offers is the inability to select particular parts of a form and restrict access to them. The easiest way to take care of that problem is to create multiple tables for a database and restrict those individually. But since I didn't create this database all on my own I was not able to ensure that my counter part create multiple tables. . . .less he created just ONE and put all the information in it. . .

Thank for the help anyways. . . .I guess I will look else where.

 

[JoeMiller]

How would access know what to restrict on a form itself?? To do that Microsoft would have to have a way to know what you were going to make on your form and design some way to restrict it. Not a simple task.

If developers need to stop people from getting at a certain control on a form (which it seems you're after) they write code that examines the username or usergroup when the form opens and then either hide/lock/disable the appropriate controls. This is very easy to do using If/Then constructs. I don't believe creating separate tables would be the way to go, but you obviously know your business better than I.

Good luck! Joe Miller
joe.miller@flotech.net