MS Access 2000 mdb file does not work well in MS Access 2007

  • Thread starter Thread starter JohnnyO
  • Start date Start date
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!!!!!!
 
Hi Johnny,

I have seen this, but have not yet tested out my theory that it is
related to being or not being an administrator of the computer. Are you an
administration? If not, you IT people may need to make you one. Perhaps
temporarily if they are not willing to do so permanently. It also may be
related to some part of Access not being installed. Did they do a complete
install of Access 2007 and the other common Office 2007 options/items? If
not, ask them to do so. Please post back to let me know if either of those
makes a difference.

Clifford Bass
 
Back
Top