Access 2000/2002

[tonysailor]

I have had a database shared over a peer to peer network for over 5 years
(originally access 1997) with no problem. Recently one of the PC's (windows
XP Prof) can not open it, it comes up with a message to say that the database
is outside the workgroup so it will not open it. The same has just happened
with a new PC (Vista). Can anyone tell me what has happened? How do I fix
it? I suspect that the XP machine is caused by a Microsoft Patch.

Help

 

[Scott McDaniel]

I have had a database shared over a peer to peer network for over 5 years
(originally access 1997) with no problem. Recently one of the PC's (windows
XP Prof) can not open it, it comres up with a message to say that the database
is outside the workgroup so it will not open it. The same has just happened
with a new PC (Vista). Can anyone tell me what has happened? How do I fix
it? I suspect that the XP machine is caused by a Microsoft Patch.

Try adding the network resource hosting the database to the Trusted Sites section on your Internet Explorer's Security
tab.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[tonysailor]

Hi Scott,

Thanks for you help, but tried that.

Regards Tony

 

[Scott McDaniel]

I have had a database shared over a peer to peer network for over 5 years
What's the exact error message you're receiveing, including the number?

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[tonysailor]

Hi Scott, sorry for the delay, the message reads:

"Microsft 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"

It is on a peer to peer PC acting as a server, the address is given out by
the router, it is accessible to any PC on the workgroup. I have tried making
it a trusted site but it doesnt help. I have tried turning off the firewall.

 

[Scott McDaniel]

Hi Scott, sorry for the delay, the message reads:

"Microsft 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"

It is on a peer to peer PC acting as a server, the address is given out by
the router, it is accessible to any PC on the workgroup. I have tried making
it a trusted site but it doesnt help. I have tried turning off the firewall.

Still sounds as if you somehow haven't correctly added the network resource to the trusted sites correctly. Read this KB
article, if you haven't already:

http://support.microsoft.com/kb/303650

If you have followed these steps exactly, then try removing the site, rebooting the macine, then adding the site again.

Are you saying the router operates as the DHCP server and assigns IP addresses? If so, can you tell the router to assign
the server PC a static IP address, then make sure to add that address to the Trusted Sites section?

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[tonysailor]

Hi Scott,

many thanks we fixed it with //server/databse/etc., I am very grateful for
your help.

Regards

Tony Leach