|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Security NOT using "mdw" fileDoes anyone know of a way to do this (please read all steps): 1. I want to setup a Design Master and 4 replicas. (I know how) 2. I want to lock out the users from design mode of all objects within the replica NOT using the "mdw" file, but some other way, requiring a password. 3. I guess that's all. 4. Help. 5. Thanks. 6. And Good Everything. 7. Bye. Kan You can't.
An MDE will prevent changes to forms, reports and modules, but they'll still be able to change tables, queries and macros. What's your objection to applying security and using a specific MDW file? -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Kan D." <nob***@nowhere.com> wrote in message news:u9Frqi00GHA.480@TK2MSFTNGP06.phx.gbl... > Greetings. > > Does anyone know of a way to do this (please read all steps): > > 1. I want to setup a Design Master and 4 replicas. (I know how) > > 2. I want to lock out the users from design mode of all objects within > the replica NOT using the "mdw" file, but some other way, requiring a > password. > > 3. I guess that's all. > > 4. Help. > > 5. Thanks. > > 6. And Good Everything. > > 7. Bye. > > Kan > well, shoot.
My objection to mdw is that, for some reason, my supervisor does not like using the mdw file. Why can't I make the replica's function in one aspect like an MDE (design of objects is disabled)? I don't want to make MDEs, but, judging from your response, I may have to. What is your response? Thanks, Kan Show quoteHide quote "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:OUgvOw00GHA.1300@TK2MSFTNGP05.phx.gbl... > You can't. > > An MDE will prevent changes to forms, reports and modules, but they'll > still be able to change tables, queries and macros. > > What's your objection to applying security and using a specific MDW file? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Kan D." <nob***@nowhere.com> wrote in message > news:u9Frqi00GHA.480@TK2MSFTNGP06.phx.gbl... >> Greetings. >> >> Does anyone know of a way to do this (please read all steps): >> >> 1. I want to setup a Design Master and 4 replicas. (I know how) >> >> 2. I want to lock out the users from design mode of all objects within >> the replica NOT using the "mdw" file, but some other way, requiring a >> password. >> >> 3. I guess that's all. >> >> 4. Help. >> >> 5. Thanks. >> >> 6. And Good Everything. >> >> 7. Bye. >> >> Kan >> > > Does your supervisor realize that Access uses an MDW file whether or not
you've applied security? And I wasn't actually recommending MDEs, as they don't appear to meet your needs (the users will still be able to make changes to tables, queries and macros) -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Kan D." <nob***@nowhere.com> wrote in message news:eqInKN10GHA.772@TK2MSFTNGP05.phx.gbl... > well, shoot. > > My objection to mdw is that, for some reason, my supervisor does not like > using the mdw file. > > Why can't I make the replica's function in one aspect like an MDE (design > of objects is disabled)? > > I don't want to make MDEs, but, judging from your response, I may have to. > > What is your response? > > Thanks, > Kan > > "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:OUgvOw00GHA.1300@TK2MSFTNGP05.phx.gbl... >> You can't. >> >> An MDE will prevent changes to forms, reports and modules, but they'll >> still be able to change tables, queries and macros. >> >> What's your objection to applying security and using a specific MDW file? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "Kan D." <nob***@nowhere.com> wrote in message >> news:u9Frqi00GHA.480@TK2MSFTNGP06.phx.gbl... >>> Greetings. >>> >>> Does anyone know of a way to do this (please read all steps): >>> >>> 1. I want to setup a Design Master and 4 replicas. (I know how) >>> >>> 2. I want to lock out the users from design mode of all objects within >>> the replica NOT using the "mdw" file, but some other way, requiring a >>> password. >>> >>> 3. I guess that's all. >>> >>> 4. Help. >>> >>> 5. Thanks. >>> >>> 6. And Good Everything. >>> >>> 7. Bye. >>> >>> Kan >>> >> >> > > Forgot to mention that you should only be replicating the tables anyhow.
"Application objects" such as forms, reports, modules and macros aren't intended to be replicated. -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:uByedU10GHA.3752@TK2MSFTNGP02.phx.gbl... > Does your supervisor realize that Access uses an MDW file whether or not > you've applied security? > > And I wasn't actually recommending MDEs, as they don't appear to meet your > needs (the users will still be able to make changes to tables, queries and > macros) > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Kan D." <nob***@nowhere.com> wrote in message > news:eqInKN10GHA.772@TK2MSFTNGP05.phx.gbl... >> well, shoot. >> >> My objection to mdw is that, for some reason, my supervisor does not like >> using the mdw file. >> >> Why can't I make the replica's function in one aspect like an MDE (design >> of objects is disabled)? >> >> I don't want to make MDEs, but, judging from your response, I may have >> to. >> >> What is your response? >> >> Thanks, >> Kan >> >> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >> news:OUgvOw00GHA.1300@TK2MSFTNGP05.phx.gbl... >>> You can't. >>> >>> An MDE will prevent changes to forms, reports and modules, but they'll >>> still be able to change tables, queries and macros. >>> >>> What's your objection to applying security and using a specific MDW >>> file? >>> >>> -- >>> Doug Steele, Microsoft Access MVP >>> http://I.Am/DougSteele >>> (no e-mails, please!) >>> >>> >>> "Kan D." <nob***@nowhere.com> wrote in message >>> news:u9Frqi00GHA.480@TK2MSFTNGP06.phx.gbl... >>>> Greetings. >>>> >>>> Does anyone know of a way to do this (please read all steps): >>>> >>>> 1. I want to setup a Design Master and 4 replicas. (I know how) >>>> >>>> 2. I want to lock out the users from design mode of all objects within >>>> the replica NOT using the "mdw" file, but some other way, requiring a >>>> password. >>>> >>>> 3. I guess that's all. >>>> >>>> 4. Help. >>>> >>>> 5. Thanks. >>>> >>>> 6. And Good Everything. >>>> >>>> 7. Bye. >>>> >>>> Kan >>>> >>> >>> >> >> > > In addition to Doug's comments regarding the replication of non-tables and
using a MDE, you can secure your application such that users use their standard system.mdw and don't have to login. See www.jmwild.com/SecureNoLogin.htm -- Show quoteHide quoteJoan Wild Microsoft Access MVP Kan D. wrote: > Greetings. > > Does anyone know of a way to do this (please read all steps): > > 1. I want to setup a Design Master and 4 replicas. (I know how) > > 2. I want to lock out the users from design mode of all objects > within the replica NOT using the "mdw" file, but some other way, > requiring a password. > 3. I guess that's all. > > 4. Help. > > 5. Thanks. > > 6. And Good Everything. > > 7. Bye. > > Kan I thought you were away on vacation!
-- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Joan Wild" <jwild@nospamtyenet.com> wrote in message news:OiHFIk10GHA.772@TK2MSFTNGP05.phx.gbl... > In addition to Doug's comments regarding the replication of non-tables and > using a MDE, you can secure your application such that users use their > standard system.mdw and don't have to login. See > www.jmwild.com/SecureNoLogin.htm > > > -- > Joan Wild > Microsoft Access MVP > > Kan D. wrote: >> Greetings. >> >> Does anyone know of a way to do this (please read all steps): >> >> 1. I want to setup a Design Master and 4 replicas. (I know how) >> >> 2. I want to lock out the users from design mode of all objects >> within the replica NOT using the "mdw" file, but some other way, >> requiring a password. >> 3. I guess that's all. >> >> 4. Help. >> >> 5. Thanks. >> >> 6. And Good Everything. >> >> 7. Bye. >> >> Kan > > <g> I am, sporadically.
-- Show quoteHide quoteJoan Wild Microsoft Access MVP Douglas J. Steele wrote: > I thought you were away on vacation! > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Joan Wild" <jwild@nospamtyenet.com> wrote in message > news:OiHFIk10GHA.772@TK2MSFTNGP05.phx.gbl... >> In addition to Doug's comments regarding the replication of >> non-tables and using a MDE, you can secure your application such >> that users use their standard system.mdw and don't have to login. See >> www.jmwild.com/SecureNoLogin.htm >> >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Kan D. wrote: >>> Greetings. >>> >>> Does anyone know of a way to do this (please read all steps): >>> >>> 1. I want to setup a Design Master and 4 replicas. (I know how) >>> >>> 2. I want to lock out the users from design mode of all objects >>> within the replica NOT using the "mdw" file, but some other way, >>> requiring a password. >>> 3. I guess that's all. >>> >>> 4. Help. >>> >>> 5. Thanks. >>> >>> 6. And Good Everything. >>> >>> 7. Bye. >>> >>> Kan On Fri, 8 Sep 2006 11:09:01 -0400, "Joan Wild"
<jwild@nospamtyenet.com> wrote: >In addition to Doug's comments regarding the replication of non-tables and I see options there for Acc97, 2002, and 2003, but not 2000.>using a MDE, you can secure your application such that users use their >standard system.mdw and don't have to login. See >www.jmwild.com/SecureNoLogin.htm Did I miss it? -- Thanks, tbl Yes, it's covered on the same page as 97.
-- Show quoteHide quoteJoan Wild Microsoft Access MVP tbl wrote: > On Fri, 8 Sep 2006 11:09:01 -0400, "Joan Wild" > <jwild@nospamtyenet.com> wrote: > >> In addition to Doug's comments regarding the replication of >> non-tables and using a MDE, you can secure your application such >> that users use their standard system.mdw and don't have to login. >> See www.jmwild.com/SecureNoLogin.htm > > > I see options there for Acc97, 2002, and 2003, but not 2000. > Did I miss it? > -- > Thanks, > tbl On Sat, 9 Sep 2006 20:53:27 -0400, "Joan Wild"
<jwild@nospamtyenet.com> wrote: >Yes, it's covered on the same page as 97. Thanks Joan!-- tbl 
Other interesting topics
Security restrictions and table linking
Allow Help Desk to Reset Passwords Without Full Admins Permissions Lost My Permissions Securing the Back-End MDW deployment? Shorcut with pointing to two ACCESS.EXE from mdb how to openForm a form in a referenced mde file Prevent all Access files from connecting to the same Workgroup? How can I lock based on certain field? Using Access 2003 security on users with 2002 Access |
|||||||||||||||||||||||
