Access 2007 Security warning even on new blank DB!

V

Vespasian

Hello,

Using Access 2007, creating a new .accdb, immediately closing, and then
opening the file gives me a security warning. When I bring up the Microsoft
Office Security Options box, a security alert says 'VBA Macro' in bold, and
indented on the next line 'Access has disabled potentially harmful content in
this database.'

There is no macro in the database. I'm not using a template, and if there's
a starter template like Normal.doc of Word fame, I haven't changed it.

Any idea what could be going on here? I do use standard, up to date, AV/FW
software. I don't want to just nerf security settings.

Vespasian
 
6

'69 Camaro

Hi, Vespasian.
Using Access 2007, creating a new .accdb, immediately closing, and then
opening the file gives me a security warning.

Please see Microsoft Access MVP Tom Wickerath's article, "Dealing With The
Trust Center," on the following Web page:

http://www.access.qbuilt.com/html/trust_center.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
R

Rick Brandt

Vespasian said:
That site is exactly what I'm NOT looking for, as indicated in OP.

Using a trusted location is NOT the same as disabling security. It is how
you deal with files that you *know* to be okay where you no longer want the
warnings.
 
V

Vespasian

I keep my access files in one folder, whether or not I create them myself or
get them from someone else.

"Using a trusted location is NOT the same as disabling security."

Sure it is, it's just an difference in scope.

Does anyone else get security notices when creating new blank databases?
 
6

'69 Camaro

Hi, Vespasian.
That site is exactly what I'm NOT looking for, as indicated in OP.

I suspect you'll change your mind rather than change the macro security
setting or use a digital certificate. And you're welcome. ;-)

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
6

'69 Camaro

Hi, Vespasian.
I keep my access files in one folder, whether or not I create them myself
or
get them from someone else.

This setup is not recommended for Access 2007, unless all of those "someone
elses" are trusted sources, such as colleagues in another department of the
same organization. Keep your own databases and those of trusted sources in
trusted locations, and all other Access databases _not_ in trusted
locations.
Does anyone else get security notices when creating new blank databases?

No one I know does any more, but they were willing to use the Trust Center
once they realized its usefulness.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
V

Vespasian

"I suspect you'll change your mind rather than"...

Perhaps, once my original question is answered... and that bring us back to
square one. Until then, I don't have the facts to make up my mind in the
first place.
 
6

'69 Camaro

Hi, Vespasian.
I don't have the facts to make up my mind in the
first place.

Perhaps the Access 2007 blog will provide the facts you are looking for:

http://blogs.msdn.com/access/archive/2005/10/19/482845.aspx

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
R

Rick Brandt

Vespasian said:
I keep my access files in one folder, whether or not I create them
myself or get them from someone else.

"Using a trusted location is NOT the same as disabling security."

Sure it is, it's just an difference in scope.

Does anyone else get security notices when creating new blank
databases?

I could be wrong, but unlike the macro warnings that might pop up when opening a
Word or Excel document, the Access warnings do not examine the file to see if
there actually are macros or code. It just assumes that there always are and
always warns you.
 
V

Vespasian

Hello Rick,

It appears to me that the VBA Macro security warning reads as if you already
have a macro in the database. It seems that you can't disable content that
doesn't exist. When I see a message like that and see nothing listed in the
macro part of the navigation bar, something seems fishy to me.

Am I totally reading this incorrectly, or could the message be worded in a
less confusing way? If the wording could be better, I'll make a suggestion.
 

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

Top