Access windows 7 Trusted public folder problem

New Windows 7 laptop with Access mdb back-end copied to public folder.  I can read/write from this laptop to other Windows 7/XP networked pc, but I cannot open these Access mdbs from other PCs on network.  "Cannot open this file. ... outside your intranet or an untrusted site.... due to potential security problems".
From a network pc (other pc) I can create an mdb on this folder and import tables.  While it's open I can see the data.  But if I close it and try to open it, I get this message.
Anyone have any ideas?   PS.  I set all permissions, sharing, etc.  but I'm missing something.
Thanks
LVL 20
clarkscottAsked:
Who is Participating?
 
clarkscottConnect With a Mentor Author Commented:
I've requested that this question be deleted for the following reason:

No one provided a solution.  I found the solution myself.  Using Internet Explorer - Tools- Settings - Trusted Sites - add path to list.   Access 2010 uses this for Trusted Sites
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Do you have the setting shown below ?
Capture1.gif
0
 
clarkscottAuthor Commented:
I only have access 7 runtime installed on this new pc.   Do I need to install the full-blown Access to set this?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
No.  You can add the Registry settings manually ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The root key for Trusted Locations ... add that sub key (or you may need the entire Security Key) ... AllowNetworkLocations.

Shown is for A2010 ...

mx
Capture1.gif
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Gunter has a little exe app that will do this for you (I tried it)


http://www.accessribbon.de/en/index.php?Trust_Center:Trusted_Locations

Scroll down to 'Tool (AppPath):'

Look at the examples ... shows how to include AllowNetworkLocations ... using Command line options.

mx

0
 
clarkscottAuthor Commented:
This user is using Access 2002.  The illustration doesn't help me out much.  Do you know what I need to do for this verson?  Thanks alot.  Banging m head, here.
0
 
mbizupCommented:
<<Access 2002>>
<<windows 7>>

Yikes!  Just making sure that is not a typo (we just don't see that combination here much)?

Try navigating to your .mdb file using Windows Explorer.

Right-click and select "Properties"

Do you see an 'Unblock' option that you can click on the General tab?
0
 
clarkscottAuthor Commented:
Yeah... It's a tavern-type business and their POS system uses Access 2000 for it's back-end.  I've add additional functionality that uses 2002 mdbs with 2003 Access front-end.   We share the mdbs between the office PS (Windows 7) and the POS station (XP).  This worked fine for a while, but then they added a ton of Security Cameras and software to the office PC and things started hanging up.  The office PC also controls the key-card entrance door.  So... let's add a laptop and put these backend Access mdbs on a shared folder.  Easier said than done.  I will mention that Access was installed on both POS and Office PC and all worked well.  We added the Windows 7 laptop, but are getting hung up on only the Access mdbs and Access security.   I tried installing Access 7 runtime (just for fun..) but didn't do anything to help the situation.   fun   fun  fun......  
I will try your suggestion when I get to the client site.  Thanks

0
 
clarkscottAuthor Commented:
I found this solution myself.  As said, Access 2010 uses Internet Explorer Trusted Sites and can be set by following the accepted solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.