Splitting FE and BE

3 Nov 2005 3:59 PM

Len

I have a database with over 200 tables with security set up. I am attempting
to split into fe and be with the wizard. All appears to work fine except for
the the permissions. The groups that were set up are not showing permissions
for the linked tables. Any suggestions. Thanks - Len

3 Nov 2005 4:37 PM

Joan Wild

The database wizard creates a new mdb and imports the tables to it. During
import, all permissions are lost on the tables.

A secure database should be split manually. See
http://www.jmwild.com/SplitSecure.htm

--
Joan Wild
Microsoft Access MVP

Len wrote:

Show quoteHide quote

> I have a database with over 200 tables with security set up. I am
> attempting to split into fe and be with the wizard. All appears to
> work fine except for the the permissions. The groups that were set up
> are not showing permissions for the linked tables. Any suggestions.
> Thanks - Len

3 Nov 2005 9:27 PM

Len

Joan - I tried the steps from your link - split the database manually and
still lost all permissions - is that expected once the database is secure. -
Len

Show quoteHide quote

"Joan Wild" wrote:

> The database wizard creates a new mdb and imports the tables to it. During
> import, all permissions are lost on the tables.
>
> A secure database should be split manually. See
> http://www.jmwild.com/SplitSecure.htm
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Len wrote:
> > I have a database with over 200 tables with security set up. I am
> > attempting to split into fe and be with the wizard. All appears to
> > work fine except for the the permissions. The groups that were set up
> > are not showing permissions for the linked tables. Any suggestions.
> > Thanks - Len
>
>
>

3 Nov 2005 9:56 PM

Joan Wild

Len wrote:

> Joan - I tried the steps from your link - split the database manually
> and still lost all permissions - is that expected once the database
> is secure. - Len

Certainly not. Are you sure that the tables were secured in the original
single mdb?

--
Joan Wild
Microsoft Access MVP

3 Nov 2005 4:47 PM

Keith W

"Len" <L**@discussions.microsoft.com> wrote in message
news:7BD79BF8-6378-4DDD-8B80-4C35784FA5E8@microsoft.com...
>I have a database with over 200 tables with security set up. I am
>attempting
> to split into fe and be with the wizard. All appears to work fine except
> for
> the the permissions. The groups that were set up are not showing
> permissions
> for the linked tables. Any suggestions. Thanks - Len

Leave the tables with no permissions except for the owner and user RWOP
queries (with permissions as appropriate) as your data sources.

Regards,
Keith.
www.keithwilby.com

3 Nov 2005 9:27 PM

Len

Keith - thanks but I do not know what you mean by RWOP queries. - Len

Show quoteHide quote

"Keith W" wrote:

> "Len" <L**@discussions.microsoft.com> wrote in message
> news:7BD79BF8-6378-4DDD-8B80-4C35784FA5E8@microsoft.com...
> >I have a database with over 200 tables with security set up. I am
> >attempting
> > to split into fe and be with the wizard. All appears to work fine except
> > for
> > the the permissions. The groups that were set up are not showing
> > permissions
> > for the linked tables. Any suggestions. Thanks - Len
>
> Leave the tables with no permissions except for the owner and user RWOP
> queries (with permissions as appropriate) as your data sources.
>
> Regards,
> Keith.
> www.keithwilby.com
>
>
>

4 Nov 2005 8:53 AM

Keith W

"Len" <L**@discussions.microsoft.com> wrote in message
news:410AD947-DDB6-475F-9AF6-2424283B718E@microsoft.com...
> Keith - thanks but I do not know what you mean by RWOP queries. - Len
>

Run With Owner's Permissions. It means you can deny access to the table
objects but still manipulate the data via the queries.

4 Nov 2005 9:17 AM

Chris Mills

> Run With Owner's Permissions. It means you can deny access to the table
> objects but still manipulate the data via the queries.
>

It's a good option to have, but I'm not really convinced it adds that much to
security, given all the other cracks in it.

Chris