Splitting FE and BE

[Guest]

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

 

[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

 

[Keith W]

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

 

[Guest]

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

 

[Guest]

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

 

[Joan Wild]

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?

 

[Keith W]

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.

 

[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