Phil
I find it easier to apply the security first and then split. That way you are sure to have the security on the tables set at the same time as the other objects.
By the bye, you might want to consider going with a do-it-yourself security since the new ACCDB file format does not allow User Level Security. Scott Diamond wrote a couple of good blogs explaining how to do this. You can read them at:
www.accesssecurityblog.com/post/Securing-Access-databases-using-Active-Directory.aspx
www.accesssecurityblog.com/post/2011/04/02/Login-Security-using-Access-VBA.aspx
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "pdk444444" <pdk444444@...> wrote:
>
> Hi Guys
>
> I have a single user database that I want to develop into a multiuser and split at the same time
>
> Is it best to split first and then apply the user security (it is mdb) or vice versa or does it make no difference?
>
> cheers
>
> Phil
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar