Securing a Single Table A97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kahuna - 31 Jan 2007 17:20 GMT

I have a secure back/front-end app in A97. Works fine and some of the config
data is held in a second secure database, which can only be accesses by a
RWOP query in the front-end.

What I'd like to do is have an - Unsecured backend - but with one table
secured to the app workgroup. i.e. only openable where the backend is opened
using the WKGRP user and password relevant.

The backend (other than this single table) should be openable with just the
system.mdw as normal.

Is this possible and how might I set this single table security using the
app WKGRP.

Any suggestions gratefully received.

Cheers

Reply to this Message

Joan Wild - 31 Jan 2007 18:48 GMT

What you would do is actually secure this 'unsecured backend' using the same
workgroup file. Restrict permissions on this one table, and then give full
permissions to the Users Group for all the other tables.

When using the system.mdw, the user will be logging in silently as Admin, a
member of the Users Group, and there be able to do everything, except they
won't be able to open your restricted table, since the Users Group won't
have permission to it, and the Admin user won't own it.

Signature

Joan Wild
Microsoft Access MVP

>I have a secure back/front-end app in A97. Works fine and some of the
>config data is held in a second secure database, which can only be accesses
[quoted text clipped - 13 lines]
>
> Cheers

Reply to this Message

Kahuna - 31 Jan 2007 19:04 GMT

Excellent feedback thanks Joan - that's where I thought it would go - was
confused about admins though. I thought if admins had access they could
override the security - removed admins group from my secured tables!

Much appreciated

> What you would do is actually secure this 'unsecured backend' using the
> same workgroup file. Restrict permissions on this one table, and then
[quoted text clipped - 22 lines]
>>
>> Cheers

Reply to this Message

Joan Wild - 31 Jan 2007 19:12 GMT

The Admins Group is different in each mdw. Only the Admin User and the
Users Group is common to all mdws. So if you secure it with your secure
mdw, the Admins Group in system.mdw won't have the same permissions as the
Admins Group in your secure mdw.

Signature

Joan Wild
Microsoft Access MVP

> Excellent feedback thanks Joan - that's where I thought it would go - was
> confused about admins though. I thought if admins had access they could
[quoted text clipped - 28 lines]
>>>
>>> Cheers

Reply to this Message