Microsoft Access Error - This file is located outside your intranet or on an untrusted site.
Having error that consistently appears on every computer would I say easier to deal but with an error that occurs on one but one another is okey it drives me crazy. I have encountered this kind of error with a Microsoft Access file which is stored on a file server. The MS Access file is accessed via shared folder but on some computers it fails in opening up.
Upon opening the access file it will pop up an error:
Microsoft Access cannot open this file.
This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems.
To open the file, copy it to your computer or an accessible network location.
The solution is like a far fetched on which concerns with the internet option settings.
Solution to the problem is to add the site to the local intranet zone:
- open Internet Explorer
- click Tools menu -> Internet options -> Security tab
- click web zone Local intranet
- click Sites button
- click Advance button
- type the shared folder address on the add site text box of the local intranet dialog box
ex. //203.159.12.5/msaccess/ - click Add button-> Ok button -> Ok button -> Ok button
After having this changes the error was resolved and Microsoft Access could now be opened without the intranet error.
Posted
on
Tuesday, December 25th, 2007 at 11:23 pm under
Thanks alot. It worked for me.
February 28th, 2008 at 5:17 pmgabby - it’s good that it worked.
March 3rd, 2008 at 10:48 amThis did not work for a connection through a VPN. The IP address was registered in the intranet sites for IE security but the error persisted when trying to open the Access database via a mapped drive in Explorer. I did notice that the shared folder was not saved when the IP and folder name was added. It shows up before you exit the tab but when returning, only the IP address is there. Thoughts?
May 21st, 2008 at 12:56 amSolved my own issue. I am using Office XP so by adding a line to the Windows HOSTS file of my computer, I could create an alias for the IP address and the issue disappeared. I mapped to the alias in Explorer where Access now recognizes the path as a trusted intranet site, no entries needed in IE for trusted sites.
May 21st, 2008 at 5:02 amThanks a lot, Its work….Good Master for you….
July 1st, 2008 at 3:35 pmI try using \ComputerName and it works without the IP address and the file directory.
October 20th, 2008 at 7:45 pmThanks for the tips.