Thursday, October 04, 2007

Access 2007 Issues With Spec Sheets

Two fixes for Today

We have recently installed Office 2007 on new computers we are ordering, and our Spec Sheet that all of our cutomer reps use would not open. It turns out that there are two fixes that must be applied.

First, we have to set Access to not show the "Action Queries"
  • Click on the Office 2007 symbol on the top left
  • Click on the "Access Options" button at the bottom right
  • Go to the Advanced Tab
  • Look Under the Editing and Confirm options
  • Uncheck the third box down, "Action queries"

Second, we also need to change the Trust Center Settings

  • Click on the Office 2007 symbol on the top left
  • Click on the "Access Options" button at the bottom right
  • Go to the Trust Center Tab
  • Click on the link to go to the Trust Center Settings on the right
  • Click on the Trusted Locations option
  • Put a check in the box to "Allow trusted locations on my network"
  • Add the location (server) of the Spec Sheet