Tags: access, across, database, files, ie7, iuse, ive, microsoft, mysql, network, oracle, reports, sql, upgraded

Access wont allow me to open files across my network

On Database » Microsoft Access

7,837 words with 4 Comments; publish: Wed, 04 Jun 2008 00:24:00 GMT; (25078.13, « »)

I'm using MS Access 2002, I've just upgraded to IE7 now the database that I

use across the network will no longer open. It reports that:

"This file is located outside your intranet or on an untrusted site.

Micrsoft Access will not open the file due to potential security problems. To

open the file, copy it to you machine or an accessible network location."

I can't copy to this PC because several people use the database from

different PC's. I tried changing the workgroups so that they are in the same

workgroup but this didn't help. This problem has happened to all the PC's

that now have IE7 on them, all other PC's work fine.

What can I do?

All Comments

Leave a comment...

  • 4 Comments
    • First, you should never share anything but data across the network. Not only

      can it be a security problem, but you will most certainly eventually corrupt

      your file. Split the database into 2 files, a back-end with just the data

      tables, and a front-end linked to it with every thing else. There is even a

      built-in wizard to help you do that:

      Tools ... Database Utilities ... Database Splitter

      Now, leaving a copy of the front-end on the server as a backup, place a copy

      of the front-end on each user's workstation. Put a shortcut on the desktop

      to the new front-end on each workstation. All you problems should now go

      away.

      Arvin Meyer, MCP, MVP

      http://www.datastrat.com

      http://www.mvps.org/access

      http://www.accessmvp.com

      "David W." <DavidW.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:5706FDCF-48EF-4CC1-A2BD-2CDA0DD00A5A.ms-access.questionfor.info.microsoft.com...

      > I'm using MS Access 2002, I've just upgraded to IE7 now the database that

      > I

      > use across the network will no longer open. It reports that:

      > "This file is located outside your intranet or on an untrusted site.

      > Micrsoft Access will not open the file due to potential security problems.

      > To

      > open the file, copy it to you machine or an accessible network location."

      > I can't copy to this PC because several people use the database from

      > different PC's. I tried changing the workgroups so that they are in the

      > same

      > workgroup but this didn't help. This problem has happened to all the PC's

      > that now have IE7 on them, all other PC's work fine.

      > What can I do?

      #1; Wed, 04 Jun 2008 00:25:00 GMT
    • From the user's point of view, is there a period ( . ) anywhere in the path

      of the database they're opening? Not always, but frequently, errors like this

      are caused by a security feature that was introduced with Access 2000 to

      prevent opening up databases through a web-page, or otherwise through the

      internet.

      "Access 2000 and Access 2002 are not designed to open a database by using a

      URL address. A fully qualified domain name (FQDN) address or an IP address

      that includes periods ( . ) in its name is identified as in the Internet zone

      and will be interpreted by Access as a URL address."

      Take a look at the following articles:

      Intranet site is identified as an Internet site when you use an FQDN or an

      IP address

      http://support.microsoft.com/kb/303650/en-us

      You receive an error message when you try to open an Access 2002 database

      from a Web Server

      http://support.microsoft.com/kb/810582/en-us

      Hope that helps!

      David

      "David W." wrote:

      > I'm using MS Access 2002, I've just upgraded to IE7 now the database that I

      > use across the network will no longer open. It reports that:

      > "This file is located outside your intranet or on an untrusted site.

      > Micrsoft Access will not open the file due to potential security problems. To

      > open the file, copy it to you machine or an accessible network location."

      > I can't copy to this PC because several people use the database from

      > different PC's. I tried changing the workgroups so that they are in the same

      > workgroup but this didn't help. This problem has happened to all the PC's

      > that now have IE7 on them, all other PC's work fine.

      > What can I do?

      #2; Wed, 04 Jun 2008 00:26:00 GMT
    • Thank You both for your help.

      The splitting of the database did allow access to the data base but stopped

      our visual basic bits working (prob badly written). Ps you had me confused at

      first as you hadn't told me about how to reset the paths when the front end

      was moved.

      I finally found a work around and that was having to add the PC to the

      trusted sites section of IE7. had tried by IP at first, this didn't work but

      it did when I tried typing it like \\server.

      "David W." wrote:

      > I'm using MS Access 2002, I've just upgraded to IE7 now the database that I

      > use across the network will no longer open. It reports that:

      > "This file is located outside your intranet or on an untrusted site.

      > Micrsoft Access will not open the file due to potential security problems. To

      > open the file, copy it to you machine or an accessible network location."

      > I can't copy to this PC because several people use the database from

      > different PC's. I tried changing the workgroups so that they are in the same

      > workgroup but this didn't help. This problem has happened to all the PC's

      > that now have IE7 on them, all other PC's work fine.

      > What can I do?

      #3; Wed, 04 Jun 2008 00:27:00 GMT
    • My office recently encountered the same problem, but we may have found a very

      simple solution. To the best of our understanding, the error message you

      received appears when trying to open an Access database fille, version 2000

      or 2002, across a network, and AFTER upgrading to Internet Explorer 7. I'm

      not a super-techy person, but the following solution worked for me. I make

      no guarantees, nor do I know if this will cause any other problems later, but

      I thought that I should share my experience with my fellow frustrated users.

      Open Internet Explorer 7.

      Tools/Internet Options/Security/Local Intranet/Sites

      UNcheck "Automatically detect intranet network."

      CHECK ALL THREE subsidiary option boxes: "include all..."

      Click OK.

      Click Apply/OK.

      Close Internet Explorer 7.

      Attempt again to open your Access file across your network.

      This problem began to appear in our office as people received the latest

      Windows XP updates, which included IE7. Hope this works for you, too. Good

      luck!

      "David W." wrote:

      > I'm using MS Access 2002, I've just upgraded to IE7 now the database that I

      > use across the network will no longer open. It reports that:

      > "This file is located outside your intranet or on an untrusted site.

      > Micrsoft Access will not open the file due to potential security problems. To

      > open the file, copy it to you machine or an accessible network location."

      > I can't copy to this PC because several people use the database from

      > different PC's. I tried changing the workgroups so that they are in the same

      > workgroup but this didn't help. This problem has happened to all the PC's

      > that now have IE7 on them, all other PC's work fine.

      > What can I do?

      #4; Wed, 04 Jun 2008 00:28:00 GMT