Order of Completion - Workgroups then Splitting?

[pat_nospam]

In what order should I complete my database now that the design stage is over. Do I setup my workgroup security and then split the database or visa versa. Once the database is split, will the workgroup security remain intact?

Thanks for the guidance!

 

[theprez]

Why do you need to split the database?

 

[pat_nospam]

Large numbers of users need to access the system simultaneously. So, as per good form in a multi-user system, I'm going to put the backend on the network server and distribute front ends to the users.

Now, back to the topic at hand, which comes first, security or splitting? And does the security remain intact?

 

[pat_nospam]

bump - Anybody? I know this is probably a pretty straightforward answer. Help please

 

[ghudson]

I personally would add the security (test your security!) and then split the db. I always secure the front end and the back end [using the same workgroup file]. As always...make a backup copy of your db before you add workgroup security to it! Make another backup before you split it. Better to be safe than sorry!

HTH

 

[ghudson]

Thanks Pat!