Security Alert in Access 2007

G

Guest

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?
 
J

Jeff Conrad

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

in message:
 
C

Chris Mills

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
 
G

Guest

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)
 
K

Keith Wilby

JamesT said:
as a side issue, why do people respond to questions when their answer is
of
little or no value at all.
Click to expand...

They are trolls, it is what they do :)

Keith.
 
C

Chris Mills

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
 
C

Chris Mills

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.
 
C

Chris Mills

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)
 
C

Chris Mills

Is this you Chris?
http://www.devcity.net/Authors/187/Chris-Mills.aspx
Click to expand...
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 (e-mail address removed) (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
 
K

Keith Wilby

Chris Mills said:
Whatever you may think of my ideas,
Click to expand...

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"
Click to expand...

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 (e-mail address removed) (the ISP no longer exists)
Click to expand...

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.
Click to expand...

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.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Macro Security Warning 1
VBA Macro Security Alert 1
enable macros for trusted publisher 0
Enable Content on a shared drive 2
Hide Database Window and unable to change security settings 1
Content Disabled 2
Access 2007 User Level Security (long) 1
Why is there a Security Alert Options button up top for each db? 1

Top