Untrusted Site

[Dalmatians]

I am working on a laptop computer running MS Access version 2002. I'm trying to access a data file located on my desktop computer via my wireless network. (Same version of Access).

I can see the file without any problems, but when I try to open it I just get the following error message:

this file is located outside your Intranet or on an untrusted site. Microsoft Access cannot open this file.

Both computers are running under Windows XP. O/S: MS Windows 5.1 service pack 2

How do I resolve this?

 

[The_Doc_Man]

I'm going to assume you are using Internet Explorer as your browser. I'm also going to assume you want to trust that site.

Using ID (not Access), visit the site. When the site's URL is in the Address line,...

Click Tools (on the menu bar) and select the SECURITY tab. Click on "Trusted Site" in the big iconic selection list that shows up in the upper part of the secuerity tab. It should enable the "APPLY" button (bottom right). Apply that setting, thing click OK to get out of the dialog, then close IE.

Try to get the file again.

If that doesn't work, you are going to have to get to the DESKTOP computer and adjust its permission. Are you using a computer share or the more advanced folder-level share? If the latter, you can protect yourself better by sharing only that folder. On the folder, you can right-click, then on the pop-up click Properties, then on the resulting dialog box, click Security. You can make the data accessible to the network that way.

Now, there is this to consider: Depending on how the O/S is set up, you might not get the permissions window. You have to be set up for "advanced file sharing" to make that work. Use windows help to get there from here.

 

[Dalmatians]

Confused....

Sorry, you've lost me. The file I'm attempting to open is located on my wireless network - how does this involve opening it using IE? (Actually I use Firefox, but IE is also on my computer).

I've tried opening the file from within Access and also by locating it via my network and clicking to open it. Either way, the error message is the same.

I've tried adding each computer's IP addresses following the directions you've described to add the URL address, but that doesn't work.

I'm also already sharing at the advanced folder level. Everything else shares and opens just fine. It's only Access I'm encountering problems with.

 

[The_Doc_Man]

Windows gets its idea of "Trust" based on the zone in which a site is defined as a member. There are a few zones, defined in IE as Trusted Sites, Restricted Sites, Internet, and Local Intranet. Your IE trust setting for the URL - and yes, even via local intranet, there is a URL - is too severe.

I do not know how to set up Firefox zones, but you can set them with IE and then use them later with Firefox, I think.

Access, based on that message, thinks your machine is in a restricted zone. I don't know how else to say it except that for your desktop machine's IP or URL, your security settings are too harsh.

Question: When you use the wireless link, are you trying to get to a system that is on the same wireless local network segment? Or are you going out to your ISP and coming back in again to the desktop system? Makes a BIG difference.