Application Security using Access Project (adp) (Access XP)

Topic

New Reply

Using a secured Access database, it is possible to restrict access to certain features of the application using a secure workgroup, setting up users and groups and then programmatically testing who is logged in and then assigning permissions based on that users group membership.

My problem is that I need to do is the same thing to an Access Project application, but an Access project cannot use the Jet database workgroup features. So far I haven’t been able to find any real information on how to secure an Access project application. If anyone has any examples, knows of any good books/magazines on this subject, I would really appreciate it, Thanks!

Reply | Quote

Replies

An Access project is a front end for SQL Server. You need to look into the SQL Server security features, groups and roles.

Reply | Quote

I understand that the data security is done through the SQL Server, what I am trying to figure out is how to use the “login” information in the Access front-end to restrict the users ability to open forms, execute command buttons, etc.

Reply | Quote

Unfortunately, as you have already discovered, you can’t apply user security to an ADP. About the only choice is to role your own security system, making forms and menu items available to some users and not to others. SQL Server security will let you do many things, but it isn’t able to prevent some users from seeing a form tab or other control, or letting some users do data entry on a form and others not.

We often choose to use an ODBC linked SQL Server for that reason among others, but if you’re well down the ADP route, it’s a fair bit of work to reverse course. Hope this clarifies things a bit.

Reply | Quote

Well, that is what I was afraid of, I briefly thought ADOX might provide a solution, but if it does I cannot figure it out. Thanks everyone for your help, I do appreciate it!

Reply | Quote