Security problem with Access 07

[Jorge Cervantes]

In the past, when I upgraded from Office 97 to Office03, I had a problem
with Access. By changing Security Lever to low (Tool > Macro> Security). I
was able to use Access databases without any problem. I have been using
Access03 for several years without any problem.

Yesterday, I installed Office 07 Suite. Then, I got a similar security
problem as I encountered during updating to Office 03. But I don't see
Tool >Macro >Security in Access 07.

When I clicked a mdb file, I see a Security Warning: Certain content in the
database has been disabled > OPTION.

When I clicked the OPTION, there were two choices:

a) Help protect me from unknown content (recommended).
b) Enable this content.

When I selected "Enable this content", I was able to open the database
without any problem. The problem is that I got to repeat this step every
time I open my database.

Could someone advise me how to fix this pain? I am a novice user.
Thanks. Jorge

 

[mcnews]

In the past, when I upgraded from Office 97 to Office03, I had a problem
with Access.  By changing Security Lever to low  (Tool > Macro> Security). I
was able to use  Access databases without any problem.   I have been using
Access03 for several years without any problem.

Yesterday, I installed Office 07 Suite. Then, I got a similar security
problem as I encountered  during updating to Office 03.   But I don'tsee
Tool >Macro >Security in Access 07.

When I clicked a mdb file, I see a Security Warning: Certain content in the
database has been disabled > OPTION.

When I clicked the OPTION, there were two choices:

a) Help protect me from unknown content (recommended).
b) Enable this content.

When I selected "Enable this content", I was able to open the database
without any problem.  The problem is that I got to repeat this step every
time I open my database.

Could someone advise me how to fix this pain?  I am a novice user.
Thanks.   Jorge

http://msdn.microsoft.com/en-us/library/bb421308.aspx

 

[Albert D. Kallal]

Could someone advise me how to fix this pain? I am a novice user. Thanks.
Jorge

You can do exactly the SAME thing you did in 2003.

Just go:

office button->access options (lower right)

trust center (left side pane)
right side click on Trust Center settings
left side..macro settings -- choose "enable all macros..."

So, above is really the same as what you did in 2003...

 

[Jorge Cervantes]

Albert,

You saved my humble life. It was great.
The problem solved.

BTW, let me ask you another related question.

With Office 03, we can check check update (Help>Check for update now) or it
automatically updated whenever updates are available.
But I do not see "check for update". Does it automatically update or how do
you handle updates?

Jorge

 

[Albert D. Kallal]

With Office 03, we can check check update (Help>Check for update now) or
it automatically updated whenever updates are available.
But I do not see "check for update". Does it automatically update or how
do you handle updates?

Again, it really much the same as before. You just go:

office button->access options.

On the left side choose "Resources".

You then see on the right side options for feed back etc...