clarkscott
asked on
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
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
ASKER
I only have access 7 runtime installed on this new pc. Do I need to install the full-blown Access to set this?
No. You can add the Registry settings manually ...
mx
mx
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
Shown is for A2010 ...
mx
Capture1.gif
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
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
ASKER
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.
<<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?
<<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?
ASKER
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 will try your suggestion when I get to the client site. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I found this solution myself. As said, Access 2010 uses Internet Explorer Trusted Sites and can be set by following the accepted solution.
Capture1.gif