[Fixed] This file is located outside your intranet or on an untrusted site…

The Problem:

You are unable to open a Microsoft Access database hosted on another computer within your local network.  Usually the following error shows:

This file is located outside your intranet or on an untrusted site. Microsoft access will not open this file due to potential security problems.
To open the file, copy it to your machine or an accessible network location.

In my case this error started because the machine that hosted the access database was switched to Vista

The Solution:

To solve the problem I had to do some research.  After performing this fix on 4 other machines I feel pretty comfortable that this fix will work for you.  If not leave a comment.

Steps:

1. Open Internet Explorer and click tools/internet options.
2. Click the ‘Security’ tab and select ‘Local Intranet’ in the ‘Select a zone…’ area.



3. Click the ’sites’ button below that section.
4. Un-check ‘Automatically detect intranet network’. Make sure other choices are checked.



5. Click ‘Advanced’
6. In the ‘Add this website to the zone:’ box, type in the following:  “file://ACCESS_MACHINE_HERE” (where the machine that hosts the access db needs to be after the “//”) then click ‘add’.

So, there you have it.  This may not be as much as a Vista issue as it is a Internet Explorer 7 issue.  That I don’t know for sure.  What I do know is that this worked for 4 machines (3 Vista and 1 XP).  Let me know your results in the comments.

Mac

This entry was posted on Sunday, March 15th, 2009 at 9:50 pm and is filed under Computers, How To, Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.