Security Alert in Access 2007 JamesT 19.07.2006 10:05:01 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

Re: Security Alert in Access 2007 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 19.07.2006 11:08:58 Um. I thought a beta-test was to provide feedback direct to the manufacturer? "JamesT" <JamesT[ at ]discussions.microsoft.com> wrote in message news:207940AA-3A6B-476D-BAEE-7ABB1EEF45FE[ at ]microsoft.com... [Quoted Text] > 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

Re: Security Alert in Access 2007 "Jeff Conrad" <jeffc[ at ]ernstbrothers.com> 19.07.2006 17:31:38 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[ at ]microsoft.com... [Quoted Text] > 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?

Re: Security Alert in Access 2007 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 20.07.2006 07:55:30 [Quoted Text] > The good news is that with 2007... The good news, Jeff, is that (at least with A2003) at least Sagekey offers to get 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

Re: Security Alert in Access 2007 JamesT 20.07.2006 08:48:02 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: [Quoted Text] > 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[ at ]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? > > >

Re: Security Alert in Access 2007 "Keith Wilby" <here[ at ]there.com> 20.07.2006 09:10:24 "JamesT" <JamesT[ at ]discussions.microsoft.com> wrote in message news:DD3BD215-6818-4589-B2DE-64BE11731E56[ at ]microsoft.com... [Quoted Text] > > 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.

Re: Security Alert in Access 2007 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 20.07.2006 09:28:24 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 "JamesT" <JamesT[ at ]discussions.microsoft.com> wrote in message news:DD3BD215-6818-4589-B2DE-64BE11731E56[ at ]microsoft.com... [Quoted Text] > 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 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[ at ]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? > > > > > >

Re: Security Alert in Access 2007 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 20.07.2006 09:47:45 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. "Keith Wilby" <here[ at ]there.com> wrote in message news:44bf45c2_1[ at ]glkas0286.greenlnk.net... [Quoted Text] > "JamesT" <JamesT[ at ]discussions.microsoft.com> wrote in message > news:DD3BD215-6818-4589-B2DE-64BE11731E56[ at ]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. > >

Re: Security Alert in Access 2007 "Keith Wilby" <here[ at ]there.com> 20.07.2006 10:00:20 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> wrote in message news:%23ipKeE%23qGHA.1368[ at ]TK2MSFTNGP05.phx.gbl... <snip nothingworthreading> See what I mean James? :-) Keith.

Re: Security Alert in Access 2007 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 20.07.2006 10:12:03 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) "Keith Wilby" <here[ at ]there.com> wrote in message news:44bf5176_1[ at ]glkas0286.greenlnk.net... [Quoted Text] > "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> wrote in message > news:%23ipKeE%23qGHA.1368[ at ]TK2MSFTNGP05.phx.gbl... > <snip nothingworthreading> > > See what I mean James? > :-) > Keith. > >

Re: Security Alert in Access 2007 "Keith Wilby" <here[ at ]there.com> 20.07.2006 12:22:06 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> wrote in message news:O8X4CS%23qGHA.4816[ at ]TK2MSFTNGP02.phx.gbl... Is this you Chris? http://www.devcity.net/Authors/187/Chris-Mills.aspx

Re: Security Alert in Access 2007 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 20.07.2006 13:09:40 [Quoted Text] > Is this you Chris? > > http://www.devcity.net/Authors/187/Chris-Mills.aspx > > No. 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 cms[ at ]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

Re: Security Alert in Access 2007 "Keith Wilby" <here[ at ]there.com> 20.07.2006 14:14:11 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> wrote in message news:uguIU1$qGHA.4680[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > > Whatever you may think of my ideas, Is that a chip on your shoulder? I have no opinions on whatever ideas you 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 > 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" I didn't accuse you of hiding anything. > > If you wish to trawl through my past posts to see if you can get one over > me, > my previous address was cms[ at ]voyager.co.nz (the ISP no longer exists) There's that chip again Chris. I have no desire to "get one over" on anyone and, again, I'm really not interested. > > 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 right. Irrelevant, but right. > > I just call a spade a spade as I see it, and I don't care how "expert" the > recipient may be. That's your prerogative, we all have the right to not care (and I don't 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.

Re: Security Alert in Access 2007 "Jeff Conrad" <jeffc[ at ]ernstbrothers.com> 20.07.2006 19:10:42 You're welcome James, glad I could help. Good luck with your project. -- 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:DD3BD215-6818-4589-B2DE-64BE11731E56[ at ]microsoft.com... [Quoted Text] > 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