Splitting FE and BE

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Len said:
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
Click to expand...

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
 
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
 
Len said:
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
Click to expand...

Certainly not. Are you sure that the tables were secured in the original
single mdb?
 
Len said:
Keith - thanks but I do not know what you mean by RWOP queries. - Len
Click to expand...

Run With Owner's Permissions. It means you can deny access to the table
objects but still manipulate the data via the queries.
 
Run With Owner's Permissions. It means you can deny access to the table
objects but still manipulate the data via the queries.
Click to expand...
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
 
Back
Top