Access wont allow me to open files across my network

[David W.]

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?

 

[Arvin Meyer [MVP]]

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.

 

[DBS]

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.]

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.