|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
user-level security and splitting databaseHello,
I have an access 2003 databse that i want to protect with user-level security and i will also split the database. My question is; which step is first; splitting the database or setting up the workgroup, groups and users? Thanks so much for any advise any one can provide... Thanks again, -H- Either way will work, but I'd recommend:
Secure it Split it, but don't use the splitter wizard as that results in unsecuring the backend - split it manually - steps at www.jmwild.com/SplitSecure.htm Joan Wild MS Access MVP Catchin'' On wrote: Show quoteHide quote > Hello, > > I have an access 2003 databse that i want to protect with user-level > security and i will also split the database. My question is; which step is > first; splitting the database or setting up the workgroup, groups and users? > > Thanks so much for any advise any one can provide... > > Thanks again, > -H- Joan,
Thanks for the heads up, but i have already split the database. Is there a way to put it back together again or to secure the be now that it is split. Thanks so much once again you guys a always so helpful... -H- Show quoteHide quote "Joan Wild" wrote: > Either way will work, but I'd recommend: > > Secure it > Split it, but don't use the splitter wizard as that results in > unsecuring the backend - split it manually - steps at > www.jmwild.com/SplitSecure.htm > > Joan Wild > MS Access MVP > > > Catchin'' On wrote: > > Hello, > > > > I have an access 2003 databse that i want to protect with user-level > > security and i will also split the database. My question is; which step is > > first; splitting the database or setting up the workgroup, groups and users? > > > > Thanks so much for any advise any one can provide... > > > > Thanks again, > > -H- > To secure the BE now that it is split.
Login to your FE. Create a new database and import all the objects from the BE. Remove all permissions for the Users Group for every object. Assign permissions for your Group(s) for the Database Object and if necessary the tables. Joan Wild MS Access MVP Catchin'' On wrote: Show quoteHide quote > Joan, > > Thanks for the heads up, but i have already split the database. Is there a > way to put it back together again or to secure the be now that it is split. > > Thanks so much once again you guys a always so helpful... > > -H- > > "Joan Wild" wrote: > >> Either way will work, but I'd recommend: >> >> Secure it >> Split it, but don't use the splitter wizard as that results in >> unsecuring the backend - split it manually - steps at >> www.jmwild.com/SplitSecure.htm >> >> Joan Wild >> MS Access MVP >> >> >> Catchin'' On wrote: >>> Hello, >>> >>> I have an access 2003 databse that i want to protect with user-level >>> security and i will also split the database. My question is; which step is >>> first; splitting the database or setting up the workgroup, groups and users? >>> >>> Thanks so much for any advise any one can provide... >>> >>> Thanks again, >>> -H- 
Other interesting topics
Some VBA Code Disabled in Access 2003.
Allowing User Permissions to a Control Synchronizing secured replicas Creating a custom encrypted file to use it as product key Security problem with Admin password How to Password for Open in Exclusive Mode Cant add new users ! please assist! ULS not working open db from readonly share User level security |
|||||||||||||||||||||||
