Access windows 7 Trusted public folder problem

clarkscott
clarkscott used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Do you have the setting shown below ?
Capture1.gif
I only have access 7 runtime installed on this new pc.   Do I need to install the full-blown Access to set this?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
No.  You can add the Registry settings manually ...

mx
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
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

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.
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013

Commented:
<<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?
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

I've requested that this question be deleted for the following reason:

No one provided a solution. &nbsp;I found the solution myself. &nbsp;Using Internet Explorer - Tools- Settings - Trusted Sites - add path to list. &nbsp; Access 2010 uses this for Trusted Sites
I found this solution myself.  As said, Access 2010 uses Internet Explorer Trusted Sites and can be set by following the accepted solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial