|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Converting to Acc07 from Acc03My Acc03 databases are secured using workgroup (user level) security. I am
in the process of converting to Acc07. How do I after upgrading to Acc07 get rid of the workgroup and still keep the databases secure? Thanks If you want user-level security, you cannot convert to the new .accdb format
in Access 2007: you need to leave your application in .mdb format. -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "dawnecia" <dawne***@discussions.microsoft.com> wrote in message news:E5180951-62A9-45F0-B555-552BA25111EF@microsoft.com... > My Acc03 databases are secured using workgroup (user level) security. I > am > in the process of converting to Acc07. How do I after upgrading to Acc07 > get > rid of the workgroup and still keep the databases secure? > > Thanks If I leave it as .mdb would I be able to add new groups and users?
Show quoteHide quote "Douglas J. Steele" wrote: > If you want user-level security, you cannot convert to the new .accdb format > in Access 2007: you need to leave your application in .mdb format. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "dawnecia" <dawne***@discussions.microsoft.com> wrote in message > news:E5180951-62A9-45F0-B555-552BA25111EF@microsoft.com... > > My Acc03 databases are secured using workgroup (user level) security. I > > am > > in the process of converting to Acc07. How do I after upgrading to Acc07 > > get > > rid of the workgroup and still keep the databases secure? > > > > Thanks > > > Yes, although you'd need to do it through code, as I don't believe Access
2007 includes an interface to simplify it. -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "dawnecia" <dawne***@discussions.microsoft.com> wrote in message news:2423DEF0-D327-4639-8E87-9FCE13B21F69@microsoft.com... > If I leave it as .mdb would I be able to add new groups and users? > > "Douglas J. Steele" wrote: > >> If you want user-level security, you cannot convert to the new .accdb >> format >> in Access 2007: you need to leave your application in .mdb format. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "dawnecia" <dawne***@discussions.microsoft.com> wrote in message >> news:E5180951-62A9-45F0-B555-552BA25111EF@microsoft.com... >> > My Acc03 databases are secured using workgroup (user level) security. >> > I >> > am >> > in the process of converting to Acc07. How do I after upgrading to >> > Acc07 >> > get >> > rid of the workgroup and still keep the databases secure? >> > >> > Thanks >> >> >> Do you know where I can kind the code to do this?
Show quoteHide quote "Douglas J. Steele" wrote: > Yes, although you'd need to do it through code, as I don't believe Access > 2007 includes an interface to simplify it. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "dawnecia" <dawne***@discussions.microsoft.com> wrote in message > news:2423DEF0-D327-4639-8E87-9FCE13B21F69@microsoft.com... > > If I leave it as .mdb would I be able to add new groups and users? > > > > "Douglas J. Steele" wrote: > > > >> If you want user-level security, you cannot convert to the new .accdb > >> format > >> in Access 2007: you need to leave your application in .mdb format. > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://I.Am/DougSteele > >> (no private e-mails, please) > >> > >> > >> "dawnecia" <dawne***@discussions.microsoft.com> wrote in message > >> news:E5180951-62A9-45F0-B555-552BA25111EF@microsoft.com... > >> > My Acc03 databases are secured using workgroup (user level) security. > >> > I > >> > am > >> > in the process of converting to Acc07. How do I after upgrading to > >> > Acc07 > >> > get > >> > rid of the workgroup and still keep the databases secure? > >> > > >> > Thanks > >> > >> > >> > > > See this page on my site for help on finding the security entry points when working with Access 2007
and MDB files: http://accessjunkie.com/faq_17.aspx -- Show quoteHide quoteJeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- "dawnecia" wrote in message: news:FCE48E09-2BE8-4BF8-B83F-42FA8F18A9AC@microsoft.com... > Do you know where I can kind the code to do this? Jeff thanks. By the way I bought your book a few days ago (Access Inside
Out). I should get it next week. Show quoteHide quote "Jeff Conrad [MSFT]" wrote: > See this page on my site for help on finding the security entry points when working with Access 2007 > and MDB files: > http://accessjunkie.com/faq_17.aspx > > -- > Jeff Conrad - Access Junkie - MVP Alumnus > SDET II - Access Test Team - Microsoft Corporation > > Co-author - Microsoft Office Access 2007 Inside Out > Presenter - Microsoft Access 2007 Essentials > http://www.accessmvp.com/JConrad/accessjunkie.html > Access 2007 Info: http://www.AccessJunkie.com > > ---------- > This posting is provided "AS IS" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.mspx > ---------- > > "dawnecia" wrote in message: > news:FCE48E09-2BE8-4BF8-B83F-42FA8F18A9AC@microsoft.com... > > > Do you know where I can kind the code to do this? > > > "dawnecia" wrote in message:
news:58BF7517-F802-43A8-B908-5FF0B10A28F5@microsoft.com... I hope you enjoy the book!> Jeff thanks. By the way I bought your book a few days ago (Access Inside > Out). I should get it next week. -- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- It's on the Ribbon tab Database Tools under the Ribbon called Administer. You
should see also the Replication Option there. If you don't see it, it is not a MDB format database. dawnecia wrote: Show quoteHide quote >Do you know where I can kind the code to do this? > >> Yes, although you'd need to do it through code, as I don't believe Access >> 2007 includes an interface to simplify it. >[quoted text clipped - 14 lines] >> >> > >> >> > Thanks -- Please Rate the posting if helps you. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1  
Other interesting topics
Problem with Upgrade MS Access 2003 to Access 2007
MS Access program protection Secure database and merging with Word files Trusted Location Problem Digital Signiture and Shift Key Bypass Why am I getting VBA Macro security warning when there are no Macr VBA Macro Security Alert Comments for Software Copy Protection Solutions Workgroup permissions for Access 97 DB (permissions error) How to Secure the folder |
|||||||||||||||||||||||
