FE/BE & User Level Security

[Duncan Edment]

OK. I now have User Level Security implemented in my
database. However, I think I might have shot myself in
the foot.

You see, I still need to split it into FE / BE. Can this
be done after the User Level Security has been applied, or
does the security need applied after the split?

Your help, advice and comments are appreciated.

Rgds & TIA.

Duncan

 

[Rick Brandt]

OK. I now have User Level Security implemented in my
database. However, I think I might have shot myself in
the foot.

You see, I still need to split it into FE / BE. Can this
be done after the User Level Security has been applied, or
does the security need applied after the split?

You might lose your table security setting if you split using the wizard (not sure),
but you definitely won't lose those setting if you split manually (which I prefer
anyway). That procedure is...

Copy existing file. Since you are copying the whole thing all of your security
settings also are copied.

In one copy you delete all of the tables and leave everything else. In the other you
delete everything except the tables. Then you open the first file and create links
to the tables in the second.