Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / May 2007

Tip: Looking for answers? Try searching our database.

Access 2000/2002

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tonysailor - 25 May 2007 10:49 GMT
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 - 25 May 2007 12:25 GMT
>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 - 25 May 2007 12:46 GMT
Hi Scott,

Thanks for you help, but tried that.

Regards  Tony

> >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
[quoted text clipped - 9 lines]
> scott@takemeout_infotrakker.com
> www.infotrakker.com
Scott McDaniel - 25 May 2007 16:50 GMT
>> >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.  

What's the exact error message you're receiveing, including the number?

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
tonysailor - 31 May 2007 08:33 GMT
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.

> >> >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
[quoted text clipped - 6 lines]
> scott@takemeout_infotrakker.com
> www.infotrakker.com
Scott McDaniel - 31 May 2007 11:02 GMT
>Hi Scott, sorry for the delay, the message reads:
>
[quoted text clipped - 6 lines]
>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 - 31 May 2007 16:49 GMT
Hi Scott,

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

Regards

Tony Leach

> >Hi Scott, sorry for the delay, the message reads:
> >
[quoted text clipped - 20 lines]
> scott@takemeout_infotrakker.com
> www.infotrakker.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.