View Full Version : Cannot open Access database on network


Keith Hawes
10-24-2007, 10:20 AM
We have 11 computers on the network. One has an Access back end file. When we try to open this file via the network some of the computers can open it others get the follwing message.

"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 machine or an
accessible network location."


Do not understand why all the coputers cannot open the same access database file. Please Help Regards Keith

KenHigg
10-24-2007, 10:32 AM
I'm guessing you have some kind of security cranked up on some of the computers...

ken

David Eagar
10-24-2007, 12:06 PM
Are all your computers running the same anti-virus software?

shadow9449
10-24-2007, 12:26 PM
We have 11 computers on the network. One has an Access back end file. When we try to open this file via the network some of the computers can open it others get the follwing message.

"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 machine or an
accessible network location."


Do not understand why all the coputers cannot open the same access database file. Please Help Regards Keith

Most likely the problem is that they are using IE7. This knocked out many networks using Access. You have to go to the security tab in IE and add the server's location as a trusted site. I don't know how anyone was supposed to know this...

SHADOW

David Eagar
10-24-2007, 12:53 PM
Shadow

Good catch - I had forgotten this one

Keith Hawes
10-24-2007, 01:45 PM
HI Dave thanks for the respose. All the computors are using AVG anti virus. Keith

Keith Hawes
10-24-2007, 01:52 PM
Hi Shadow thanks for the respose. Not sure what IE7 is. All the computors are using AVG anti virus. Keith

boblarson
10-24-2007, 01:57 PM
How about checking the XP firewall to see if it is letting things through. We had that problem here the other day.

David Eagar
10-24-2007, 01:58 PM
IE7 - Internet Explorer 7 - it has some 'wonderful' features like this one. Without group policies on your network, users can have endless fun knocking out software by changing IE7 settings

Keith Hawes
10-24-2007, 01:59 PM
HI Ken thanks for the response. Can you suggest where I might check the security. Keith

Keith Hawes
10-24-2007, 02:14 PM
Hello Dave I will check tomorrow to see if we have IE7. Can internet settings effect access software or a network. If we do use IE7 can you suggest where and how I should alter the settings. Keith

Keith Hawes
10-24-2007, 02:23 PM
Hi Dave Found security setting on IE7 but still do not understand quite what to alter as when we are networking we are not going through the internet. Keith

Keith Hawes
10-24-2007, 02:29 PM
Helo Bob thank you for your suggestion. I had thought of the firewall and every thing seems to be correct. The relevant boxes are ticked including File and printer sharing. Is there other areas of the firewall I should be checking.