Secure Database Before or After Split?

[Guest]

I was just wondering what the school of thought on this is, I haven't been
able to find too much information on it other that what is in the Security
FAQ. What are the implications of applying security to a database before you
split it versus after it has been split to FE/BE?

 

[Joan Wild]

I was just wondering what the school of thought on this is, I haven't been
able to find too much information on it other that what is in the Security
FAQ. What are the implications of applying security to a database before
you
split it versus after it has been split to FE/BE?

6 of one, 1/2 dozen of the other really.

If you secure first, and then split, don't use the splitter wizard as that
will result in an unsecure backend. Instead split it manually. Steps at
www.jmwild.com/SplitSecure.htm

If you split first, and secure the frontend, you then just need to be sure
you open a session using the secure mdw, and then proceed to secure the
backend (this ensures you are securing both mdb files using the same secure
workgroup file).