MSAccess 2003 mdb file does not work well in MSAccess 2007

J

JohnnyO

I have a database file that was originally created in MS Access 2000, later
upgraded to MS Access 2003 and it worked fine in both versions. My company
has recently upgraded its MS Office 2003 suite to MS Office 2007. Since the
upgrade, the MS Access files have not worked well. This mdb file uses many
macro commands and it seems the macros have been disabled. In fact, I get
security warnings concerning the macros. Here's what I've done to correct
this issue:

1.) In the following menu protocol: "Access Options" --> "Trust Center" -->
"Trust Center Settings" --> "Macro Settings", the "Disable All Macros with
Notification" is selected and all multiple choice options are "greyed" to
prevent me from changing (I assume it is a default setting by our company and
they are preventing anyone to change for security reasons).

2.) In the following menu protocol: "Access Options" --> "Trust Center" -->
"Trust Center Settings" --> "Trusted Locations", I've entered the domain path
of the database in the trusted locations.

This mdb file is a multi-user database file that executes primarily from
macros. This issue is creating a work stoppage. I assume this is a security
issue; therefore I'm posting it in "Access Database Security". Please
Advise!!!!!!
 
P

Phil Smith

Your new version of Access really has it's issues, and that is one of them.

Hit the little round button in the top left corner, then The button near
the bottom ot the window called "Access Options." Click "Trust Center "
and hit the button "Trust Center Settings." Choose the option "Trusted
Locations."

Whatever path your database De Jour resides in must be placed in that
list, otherwise, macros that change data, create files, etc. will simply
not work.

Either that, or you need to get all of those dataases Digitally signed.
 

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