OHSU's Software Forum

weatherc · Joined: 17 Mar 2008 Posts: 2

For your old Access databases and spreadsheets/documents with user macros to work in Office2007, you will need to declare their directories as trusted. Complete the following steps for each of the four Microsoft applications (Access, Excel, Word, and Powerpoint).

1. Click the Office Button (four colored squares in the upper left of Access)
2. Click the "Access Options" button
3. Click "Trust Center"
4. Click "Trust Center Settings"
5. Click "Trusted Locations"
6. Check the box "Allow Trusted Locations on My Network"
7. Add New Location
8. Browse to a folder (for instance, your H: drive)
9. Check "Subfolders of this location are also trusted"

Do this for your H: drive, I: drive, J: drive, as well as any important directories on your C: drive (unfortunately, it won't let you trust your entire C: drive).