|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Security Alert in Access 2007I am testing the Office 2007 Beta and I am pleased with a lot of the new
features. However one feature is really bugging me. It is the Security Alert in Access. Why does it keep asking me if I want to enable contents and then it asks again. My computer created the databases that I am testing so why can't Access assume that I want to 'enable content'. Why is there not a button to 'always enable content' because I trust it. Is there a way to do this that I have missed? -- JamesT Um. I thought a beta-test was to provide feedback direct to the manufacturer?
Show quoteHide quote "JamesT" <Jam***@discussions.microsoft.com> wrote in message news:207940AA-3A6B-476D-BAEE-7ABB1EEF45FE@microsoft.com... > I am testing the Office 2007 Beta and I am pleased with a lot of the new > features. However one feature is really bugging me. It is the Security Alert > in Access. > Why does it keep asking me if I want to enable contents and then it asks > again. > > My computer created the databases that I am testing so why can't Access > assume that I want to 'enable content'. Why is there not a button to 'always > enable content' because I trust it. > > Is there a way to do this that I have missed? > -- > JamesT Hi James,
The security alert stuff has been much improved in 2007 over 2003. Instead of getting forced to click through about 285 prompt screens in 2003 <g>, Access 2007 just displays one message on the Document Action Bar. The content can temporarily be turned on by clicking the "Enable Content" which you have already found. However, Access will still disable the harmful content the next time you open the file. The good news is that with 2007 you can define any number of folders (even ones on a server) as a "Trusted Location." Any database files placed in that folder are treated as trusted which means *no* more prompts at all. Cool, huh? So how do you set this up? Follow these steps: 1. Click the Microsoft Office Button in the upper left to display the new File Menu 2. Click the Access Options button near the bottom right corner of the File Menu to open the Access Options dialog box. 3. Click the Trust Center tab on the left side column. 4. Click the Trust Center Settings button on the Trust Center tab. 5. A new dialog box appear called Trust Center. One of the tabs on here is Trusted Locations. 6. Click the Trusted Locations tab. 7. On this tab look for the button called Add New Location in the bottom right corner. 8. Now browse to a folder you want to designate as trusted. 9. There is an additional check box on this dialog box that says, "Subfolders of this location are also trusted." If you check that box, any subfolders and subdirectories within that main folder will be trusted. 10. Click Ok on that dialog box and your new trusted location is listed above. 11. Keep hitting OK to back out of all the option screens. 12. Now close Access completely. 13. Move any database files to this folder which *you* deem as trustworthy. 14. Open one up and observe no more nagging prompts or messages. Sweet. :-) Any files that you may be concerned about, just don't open them from that trusted location. -- Show quoteHide quoteJeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conradsystems/accessjunkie.html http://www.access.qbuilt.com/html/articles.html "JamesT" wrote in message: news:207940AA-3A6B-476D-BAEE-7ABB1EEF45FE@microsoft.com... > I am testing the Office 2007 Beta and I am pleased with a lot of the new > features. However one feature is really bugging me. It is the Security Alert > in Access. > Why does it keep asking me if I want to enable contents and then it asks > again. > > My computer created the databases that I am testing so why can't Access > assume that I want to 'enable content'. Why is there not a button to 'always > enable content' because I trust it. > > Is there a way to do this that I have missed? > The good news is that with 2007... The good news, Jeff, is that (at least with A2003) at least Sagekey offers toget rid of all the claptrap of annual licensing fees for no other purpose than the developer's keen desire to hand over money. So far as I know, they have yet to analyse/offer on A2007. I have less association with Sagekey than you have with (let me think) QBuilt. Regards Chris Thanks, that did it.
as a side issue, why do people respond to questions when their answer is of little or no value at all. It would be better if they did not bother at all (Chris Mills take note) -- Show quoteHide quoteJamesT "Jeff Conrad" wrote: > Hi James, > > The security alert stuff has been much improved in 2007 over 2003. Instead of getting forced to > click through about 285 prompt screens in 2003 <g>, Access 2007 just displays one message on the > Document Action Bar. The content can temporarily be turned on by clicking the "Enable Content" which > you have already found. However, Access will still disable the harmful content the next time you > open the file. > > The good news is that with 2007 you can define any number of folders (even ones on a server) as a > "Trusted Location." Any database files placed in that folder are treated as trusted which means *no* > more prompts at all. Cool, huh? > > So how do you set this up? > > Follow these steps: > 1. Click the Microsoft Office Button in the upper left to display the new File Menu > 2. Click the Access Options button near the bottom right corner of the File Menu to open the Access > Options dialog box. > 3. Click the Trust Center tab on the left side column. > 4. Click the Trust Center Settings button on the Trust Center tab. > 5. A new dialog box appear called Trust Center. One of the tabs on here is Trusted Locations. > 6. Click the Trusted Locations tab. > 7. On this tab look for the button called Add New Location in the bottom right corner. > 8. Now browse to a folder you want to designate as trusted. > 9. There is an additional check box on this dialog box that says, "Subfolders of this location are > also trusted." If you check that box, any subfolders and subdirectories within that main folder will > be trusted. > 10. Click Ok on that dialog box and your new trusted location is listed above. > 11. Keep hitting OK to back out of all the option screens. > 12. Now close Access completely. > 13. Move any database files to this folder which *you* deem as trustworthy. > 14. Open one up and observe no more nagging prompts or messages. Sweet. :-) > > Any files that you may be concerned about, just don't open them from that trusted location. > > -- > Jeff Conrad > Access Junkie - MVP > http://home.bendbroadband.com/conradsystems/accessjunkie.html > http://www.access.qbuilt.com/html/articles.html > > "JamesT" wrote in message: > news:207940AA-3A6B-476D-BAEE-7ABB1EEF45FE@microsoft.com... > > > I am testing the Office 2007 Beta and I am pleased with a lot of the new > > features. However one feature is really bugging me. It is the Security Alert > > in Access. > > Why does it keep asking me if I want to enable contents and then it asks > > again. > > > > My computer created the databases that I am testing so why can't Access > > assume that I want to 'enable content'. Why is there not a button to 'always > > enable content' because I trust it. > > > > Is there a way to do this that I have missed? > > > "JamesT" <Jam***@discussions.microsoft.com> wrote in message They are trolls, it is what they do :-)news:DD3BD215-6818-4589-B2DE-64BE11731E56@microsoft.com... > > as a side issue, why do people respond to questions when their answer is > of > little or no value at all. Keith. And Keith Wilby CLAIMS to be interested in Access Security, whilst making CUTE
statements like "look up Google to break it", whereas he might just as well give out the URL's for all his BS. Keith, Access Security is by most accounts USELESS. Why then, would you have any further interest in it. As we all know (all Access Developers), the remit on your website, that you produce "Secure Access Apps", is PATENT BS (and neither are you 45yrs old for that matter) Cheers. Allow that others can think, Cutey. Show quoteHide quote "Keith Wilby" <h***@there.com> wrote in message news:44bf45c2_1@glkas0286.greenlnk.net... > "JamesT" <Jam***@discussions.microsoft.com> wrote in message > news:DD3BD215-6818-4589-B2DE-64BE11731E56@microsoft.com... > > > > as a side issue, why do people respond to questions when their answer is > > of > > little or no value at all. > > They are trolls, it is what they do :-) > > Keith. > > "Chris Mills" <phad_nospam@cleardotnet.nz> wrote in message <snip nothingworthreading>news:%23ipKeE%23qGHA.1368@TK2MSFTNGP05.phx.gbl... See what I mean James? Show quoteHide quote :-) Keith. and whilst I'm at it, Joan Wild, who has the highest technical respect from
me, is on record as stating that she DOES NOT USE Access Security for "security". Which leads one to wonder, whyever does she bother in this newsgroup? (Mary Chipman gave up many years ago for precisely this reason) Show quoteHide quote "Keith Wilby" <h***@there.com> wrote in message news:44bf5176_1@glkas0286.greenlnk.net... > "Chris Mills" <phad_nospam@cleardotnet.nz> wrote in message > news:%23ipKeE%23qGHA.1368@TK2MSFTNGP05.phx.gbl... > <snip nothingworthreading> > > See what I mean James? > :-) > Keith. > > "Chris Mills" <phad_nospam@cleardotnet.nz> wrote in message Is this you Chris?news:O8X4CS%23qGHA.4816@TK2MSFTNGP02.phx.gbl... http://www.devcity.net/Authors/187/Chris-Mills.aspx
I'm aware that there are at least two Chris Mills in my country associated
with IT (the other one nothing to do with MS-Access) I'm also aware that there IS another Chris Mills (legitimate so far as I can tell after an MVP alerted me) who has sometimes posts in the Access newsgroups. Whatever you may think of my ideas, I have never attempted to hide under anonymity in the approx 10 years I've been interested in Access newsgroups. I think I'm identifiable by my slightly corrupted but nevertheless true address of "phad" (it's the name of my yacht if you must know). If you wish to trawl through my past posts to see if you can get one over me, my previous address was c**@voyager.co.nz (the ISP no longer exists) I assure you, I do nothing other than post under my own name, and admit responsibility for any bad posts. I also never advertise in the newsgroups. You don't know what my products are, good or bad. I just call a spade a spade as I see it, and I don't care how "expert" the recipient may be. Chris "Chris Mills" <phad_nospam@cleardotnet.nz> wrote in message Is that a chip on your shoulder? I have no opinions on whatever ideas you news:uguIU1$qGHA.4680@TK2MSFTNGP02.phx.gbl... > > Whatever you may think of my ideas, might have, I'm really not interested. I only asked if it was you because I like to put faces to names, nothing sinister. > I have never attempted to hide under I didn't accuse you of hiding anything.> anonymity in the approx 10 years I've been interested in Access > newsgroups. I > think I'm identifiable by my slightly corrupted but nevertheless true > address > of "phad" > There's that chip again Chris. I have no desire to "get one over" on anyone > If you wish to trawl through my past posts to see if you can get one over > me, > my previous address was c**@voyager.co.nz (the ISP no longer exists) and, again, I'm really not interested. > That's right. Irrelevant, but right.> I assure you, I do nothing other than post under my own name, and admit > responsibility for any bad posts. > > I also never advertise in the newsgroups. You don't know what my products > are, > good or bad. > That's your prerogative, we all have the right to not care (and I don't > I just call a spade a spade as I see it, and I don't care how "expert" the > recipient may be. think I've ever claimed "expert" status). I personally don't care if someone doesn't like Access security, that again is their prerogative. What can be irritating, though, is when someone whose opinion is already well documented keeps droning on and on about it like my mother-in-law. I know when Access security is adequate and I know when to use Oracle instead, in the same way that I know when to use a padlock and when to use a bank vault - it's all about risk assessment, not being nagged. Keith. Because Access, since 2003, has had features, which you have to pay to disable
or otherwise be a techo-wizz to disable via the Registry, to do with "Trusting", "Enabling" and such terms. If the question was not related to the relatively new "Licensing" (since A2003), to suppress pesky "Trusted" issues, then my apologies wrong planet. The original post mentioned "Security Alerts" and asking "pesky Enable questions". Are you saying the question was unrelated to buying licensing to suppress pesky alert questions? This has been a big bug-bear and bone of contention ever since A2003. If such is off-topic, for this thread, then my apologies. Chris Show quoteHide quote "JamesT" <Jam***@discussions.microsoft.com> wrote in message of getting forced tonews:DD3BD215-6818-4589-B2DE-64BE11731E56@microsoft.com... > Thanks, that did it. > > as a side issue, why do people respond to questions when their answer is of > little or no value at all. It would be better if they did not bother at all > (Chris Mills take note) > -- > JamesT > > > "Jeff Conrad" wrote: > > > Hi James, > > > > The security alert stuff has been much improved in 2007 over 2003. Instead > > click through about 285 prompt screens in 2003 <g>, Access 2007 just displays one message on the> > Document Action Bar. The content can temporarily be turned on by clicking the "Enable Content" which> > you have already found. However, Access will still disable the harmful content the next time you> > open the file. ones on a server) as a> > > > The good news is that with 2007 you can define any number of folders (even > > "Trusted Location." Any database files placed in that folder are treated as trusted which means *no*> > more prompts at all. Cool, huh? File Menu to open the Access> > > > So how do you set this up? > > > > Follow these steps: > > 1. Click the Microsoft Office Button in the upper left to display the new File Menu > > 2. Click the Access Options button near the bottom right corner of the > > Options dialog box. "Subfolders of this location are> > 3. Click the Trust Center tab on the left side column. > > 4. Click the Trust Center Settings button on the Trust Center tab. > > 5. A new dialog box appear called Trust Center. One of the tabs on here is Trusted Locations. > > 6. Click the Trusted Locations tab. > > 7. On this tab look for the button called Add New Location in the bottom right corner. > > 8. Now browse to a folder you want to designate as trusted. > > 9. There is an additional check box on this dialog box that says, > > also trusted." If you check that box, any subfolders and subdirectories within that main folder willShow quoteHide quote > > be trusted. > > 10. Click Ok on that dialog box and your new trusted location is listed above. > > 11. Keep hitting OK to back out of all the option screens. > > 12. Now close Access completely. > > 13. Move any database files to this folder which *you* deem as trustworthy. > > 14. Open one up and observe no more nagging prompts or messages. Sweet. :-) > > > > Any files that you may be concerned about, just don't open them from that trusted location. > > > > -- > > Jeff Conrad > > Access Junkie - MVP > > http://home.bendbroadband.com/conradsystems/accessjunkie.html > > http://www.access.qbuilt.com/html/articles.html > > > > "JamesT" wrote in message: > > news:207940AA-3A6B-476D-BAEE-7ABB1EEF45FE@microsoft.com... > > > > > I am testing the Office 2007 Beta and I am pleased with a lot of the new > > > features. However one feature is really bugging me. It is the Security Alert > > > in Access. > > > Why does it keep asking me if I want to enable contents and then it asks > > > again. > > > > > > My computer created the databases that I am testing so why can't Access > > > assume that I want to 'enable content'. Why is there not a button to 'always > > > enable content' because I trust it. > > > > > > Is there a way to do this that I have missed? > > > > > > You're welcome James, glad I could help.
Good luck with your project. -- Show quoteHide quoteJeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conradsystems/accessjunkie.html http://www.access.qbuilt.com/html/articles.html "JamesT" wrote in message: news:DD3BD215-6818-4589-B2DE-64BE11731E56@microsoft.com... > Thanks, that did it. > > as a side issue, why do people respond to questions when their answer is of > little or no value at all. It would be better if they did not bother at all > (Chris Mills take note) > -- > JamesT 
Other interesting topics
Access-New User-Help!!
Security nightmare - 2 mdw's mixed up Diff Workgroups, Same DB, diff Security can't run report from crystal reports log on screen in Access? Programatically hide and unhide the database window Self-Signed Certificate how to export? Switchboard Security search form not working properly Access 2000 Security - Workgroup, Owner, User Permissions etc., H |
|||||||||||||||||||||||
