I am admintering a FE/BE split database that has been recently upgraded from 2003 to 2010.
I want to remove the current user-level security and implement my own. i have looked at the solution...
...and an happy to give it a bash but I don't know how to access the user-level security menu in 2010. I can get to the Workgroup admin by doing docmd.RunCommand acCmdWorkgroupAdministrato
r but what is the command to access the other security functions?
I get asked to enter my user name no matter which database I open. Even if I create a brand new database, it still gets saddled with a user log-in, something I was led to believe was impossible as it uses the new ACCDB table format. Is this normal behaviour.
I have a split database. Would it be wise to create an unsplit version and use that before following the instructions in the link above?
Too many questions??? I can split (haha) if you want me to...