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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
No.  You can add the Registry settings manually ...

mx
0
Determine the Perfect Price for Your IT Services

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

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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 Architect / Systems AnalystCommented:
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'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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.