Unable to open database residing in another computer of network

Unable to open database residing in another computer of network

am 25.10.2007 10:43:28 von shriil

Hi

I am facing a problem with regard to opening of Access Databases,
resident on pcs of my office network connected thru LAN, from my
machine on the network. The folders in which these databases reside
are in full share mode and the folders are accessible. All the network
machines including mine have Windows XP SP2 OS and Access 2002. All
the versions are registered.
Whenever I am double clicking an Access Database on the network, the
first message which is flashed is like this:

Security Warning: Do you want to open the file ?
Name: xyz.mdb
Publisher: Unknown Publisher
Type: Microsoft Access application

After pressing the "yes" button, the following message is displayed:

"Microsoft Access cannot open the file. The 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"

Can't fathom why the security warning is being displayed and why is it
saying that it is outside my intranet. The folder is accessible and
visible. Suprisingly, I can copy the database from the network
computer in which it resides and paste it into the machine from which
I am operating. Once it is on my machine, the database can be opened.

I checked the security settings of the Internet zones on my computer.
The 'intranet' security setting is set at 'medium-low'.
"Automatically detect intranet" checkbox is also checked.

Pls help!!

Re: Unable to open database residing in another computer of network

am 25.10.2007 15:58:41 von OldPro

On Oct 25, 3:43 am, shriil wrote:
> Hi
>
> I am facing a problem with regard to opening of Access Databases,
> resident on pcs of my office network connected thru LAN, from my
> machine on the network. The folders in which these databases reside
> are in full share mode and the folders are accessible. All the network
> machines including mine have Windows XP SP2 OS and Access 2002. All
> the versions are registered.
> Whenever I am double clicking an Access Database on the network, the
> first message which is flashed is like this:
>
> Security Warning: Do you want to open the file ?
> Name: xyz.mdb
> Publisher: Unknown Publisher
> Type: Microsoft Access application
>
> After pressing the "yes" button, the following message is displayed:
>
> "Microsoft Access cannot open the file. The 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"
>
> Can't fathom why the security warning is being displayed and why is it
> saying that it is outside my intranet. The folder is accessible and
> visible. Suprisingly, I can copy the database from the network
> computer in which it resides and paste it into the machine from which
> I am operating. Once it is on my machine, the database can be opened.
>
> I checked the security settings of the Internet zones on my computer.
> The 'intranet' security setting is set at 'medium-low'.
> "Automatically detect intranet" checkbox is also checked.
>
> Pls help!!

Look up article #929798 on the Microsoft Knowledgebase. I beleive
it's related.
http://support.microsoft.com/kb/929798/en-us