Security problem with Access 07

  • Thread starter Thread starter Jorge Cervantes
  • Start date Start date
J

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

http://msdn.microsoft.com/en-us/library/bb421308.aspx
 
Could someone advise me how to fix this pain? I am a novice user. Thanks.
Jorge
Click to expand...

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

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...
 
Back
Top