Problems with untrusted site

[Zorcon]

I am using Access XP on a new Dell laptop tied in with a peer-to-peer
network. I can open Word documents that reside on a different computer but I
cannot open Access files. I get an error: "This file is located ooutside or
intranet or on an untrusted site...." I must need to set something in Access
to be able to open these files. I am able to open the files on other
computers, and I was always able to open them on my old laptop. What do I
need to reset and how do I do it?

 

[Wayne-I-M]

Hi

Open access (but not a database).
Select View
Sellect security
Select level you want
Save

 

[Zorcon]

There is no "security" option under view in Access 2002. So How do I reset
security?

 

[Wayne-I-M]

ooops - sorry, it's on the Tools Tab not the view tab.

 

[Zorcon]

From Tools/Security, Wayne, I get "User and Group accounts" and "Workgroup
Administrator" (neither addresses the issue). What do you think I am going to
find when I click Security?

 

[Wayne-I-M]

You have a database open.

Close it (click the small black X in the top right of the screen - NOT the
red X)

After you have closed the DB then click tools

Hope this helps

 

[Zorcon]

What happens on your Access 2002 when you have no database open and then you
click Tools and then you click Security? What do you see? I'm sorry to be
"dense" on this but I am dealing with Access 2002, not Word or Excel.

 

[Wayne-I-M]

I assume that your db won't open as it is the macros that are causeing the
security issues

Click Tools
Select macro
Select security
Select low
Save

If this doesn't work I'm lost - as it works on mine - I have asscess 2000
and 2003 and it works on both.

 

[Arvin Meyer [MVP]]

I am using Access XP on a new Dell laptop tied in with a peer-to-peer
network. I can open Word documents that reside on a different computer but
I
cannot open Access files. I get an error: "This file is located ooutside
or
intranet or on an untrusted site...." I must need to set something in
Access
to be able to open these files. I am able to open the files on other
computers, and I was always able to open them on my old laptop. What do I
need to reset and how do I do it?

That's one of the Windows security enhancements in Service Pack 2 or
possibly one of the hotfixes. Find the file in Windows Explorer, right-click
and choose Properties, uncheck the box at the bottom.

 

[Zorcon]

The only two boxes at the bottom of the properties page are Read Only and
Hidden and both are unchecked.

 

[Arvin Meyer [MVP]]

Files introduced from another computer are tagged and you must uncheck a
property that states something like: This files may be unsafe because it
comes from another computer. The is a checkbox that allows you to Unblock
the file.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Zorcon]

Thank you for your help, Arvin. I am unable to find that box anywhere. I am
running XP Professional. When I right-click the file name on the other
computer I get the properties box with tabs for General Security and Summary
but I see no check box as you describe. Can you give me any more information?
I really appreciate your help!

 

[Guest]

and choose Properties, uncheck the box at the bottom.

You need to be an Administrator on your PC to see that box.

Yes, Access gets special treatment. As if Word never had
macro viruses, and Access ever did. Like they used to say
about Novell DOS: the job's not done till Access won't run.

However, to make a true comparison, you need to create a
new Access database, then copy it to the target location.

If the new database won't open, it's a Windows problem:
the location is not a trusted location. You use Internet Explorer
or Office 2007 to set and change trusted locations.

If the new database will open, it's a file property problem
with the real database, as discussed above, and you need
to have the pc/network administration privilege to reset
that file property.

(david)

 

[Mr B]

Zorcon,

The option to change or "Unlock" a file that came from another computer, is
located in the Properties dialog box of the file.

Using the Windows Explorer, locate the file, right click and select
properties. Then look for the "Button", not a checkbox, that says "Unlock".
Click it. This will reset the file and you will be able to open it.
--
HTH

Mr B
email if needed to:
draccess at askdoctoraccess dot com

 

[Zorcon]

Thanks, David. I'm getting closer. I cannot open a database I created on my
machine if it is moved to my secretary's hard drive. Therefore, I need to
create a safe zone for her machine. The problem is that because we use a
Toshiba network copier in our office we need to let the network assign IP
addresses. In Norton Internet Security a created a trusted zone for a range
of IP addresses. Can I do the same thing through IE7? How

 

[Zorcon]

Thanks for your help, Mr B.

I see no button in the properties screen for databases stored on my
secretary’s computer (I get to these through Windows Explorer). It doesn’t
matter whether I log on to my computer as my User identity or as
Administrator. There’s no button that says Unlock. I’m using Windows XP
Professional on a new Dell Latitude and we have a simple peer-to-peer network
with automatic IP addressing. What am I doing wrong?

Thanks for your help!

 

[Arvin Meyer [MVP]]

I see no button in the properties screen for databases stored on my
secretary's computer (I get to these through Windows Explorer). It doesn't
matter whether I log on to my computer as my User identity or as
Administrator. There's no button that says Unlock. I'm using Windows XP
Professional on a new Dell Latitude and we have a simple peer-to-peer
network
with automatic IP addressing. What am I doing wrong?

It seems to be a Windows machine or network permissions problem. You may
need to have an admin fix it for you, or perhaps hire an outside network
expert. You may get lucky asking in one of the Windows networking
newsgroups.

 

[Zorcon]

Thanks for checking in again, Arvin. I was able to fix it 5 minutes ago with
a Dell tech. By adding the name of the computer to the trusted sites in IE7
(\\CompName which converts to File://CompName when you click the Add button)
and then restarting the computer, I was able to start opening Access files on
other computers.

Thanks for your help.

 

[Arvin Meyer [MVP]]

Thanks for checking in again, Arvin. I was able to fix it 5 minutes ago
with
a Dell tech. By adding the name of the computer to the trusted sites in
IE7

IE7 was the culprit. ... I guess we need to start looking beyond Windows to
find permissions gremlins now.