Can't open Access database

  • Thread starter Thread starter Steve Kushubar
  • Start date Start date
S

Steve Kushubar

I am trying to open an Access database sent to me by a colleague. I get the
following error message:

"MS Access cannot open this file.

"This file is located outside your intranet or on an untrusted site. MS
Access will not open the file due to potential security problems.

"To open this file, copy it to your machine or to an accessible network
location."

The error msg makes no sense, since the file is on my local machine.

I'm using MS Office XP Pro. SP3 and Windows XP Pro SP2.

Any suggestions?


Steve Kushubar
 
Thanks, I did see your response to an earlier post to a similar question.
These links do not relate to opening a database on a local harddrive.

Steve
 
Hi Steve,

As I mentioned, this is really not my area of expertise.
The only thing that comes to my (limited) mind is that
the file uses some table links to a network share????
That's just a guess though. Can your colleague confirm
or deny that?
 
I am having exactly the same problem - a friend has tried to design me
something and has sent it by email. As far as I know there are no other
relationships with anything else she has done. I too have saved it to my c
drive and in the file manager it looks as if it is just a standard Access db

Any other suggestions most gratefully received

Angela
 
I sent the database to someone else who doesn't have access to anything on
our network and he was able to open it with no problem. It seems to be
either Windows XP or Office XP SP3, which are unique to me.

Steve
 
Could well be - I have XP as well. I am planning to try and open it at
work where we are on a network and not XP.

Angela
 
Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.
 
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.
 
Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.
Click to expand...

This is just another "well intended" screw up on MS part. My understanding of
how this feature is *supposed to work* is that you get a warning about the file,
but along with the warning is the option to open the file "if you are sure about
its organ". Choosing that option then removes the block from the file. Instead
you get this very badly worded message and are not offered any information about
what you are supposed to do that is actually helpful (or even accurate).

Zip files are worse. If you send a Zip file to someone with SP2, XP will treat
it as a compressed folder and let you view the files contained within, but if
you attempt to extract them (either explicitly or by dragging and dropping) you
get an error message that suggests that the compressed volume is corrupted.
Once you "Unblock" the zip file then everything is fine. The number of support
calls caused by this must be huge.
 
Thanks Ken - that did the trick. I have to agree with Rick that this is a
poorly implemented/documented feature. I have no clue what caused the
system to "block" the file, but it seems like access could have told me how
to open the file if I really wanted to.

Thanks again to everyone for the help ... I can't afford to pull out much
more hair :-)


Steve

Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.

--

Ken Snell
<MS ACCESS MVP>


Jeff Conrad said:
Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.
Click to expand...
Click to expand...
 
I am using Windows XP SP2 and Office XP, and have not seen this blocking
feature at all with files that I put on my hard disk from email attachments,
etc. I will have to see if I can reproduce it on my PC somehow so that I'll
better understand what's happening. Do you know if it relates to whether the
user is logged in as Administrator or as a regular user?
--

Ken Snell
<MS ACCESS MVP>



Rick Brandt said:
Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.
Click to expand...

This is just another "well intended" screw up on MS part. My
understanding of how this feature is *supposed to work* is that you get a
warning about the file, but along with the warning is the option to open
the file "if you are sure about its organ". Choosing that option then
removes the block from the file. Instead you get this very badly worded
message and are not offered any information about what you are supposed to
do that is actually helpful (or even accurate).

Zip files are worse. If you send a Zip file to someone with SP2, XP will
treat it as a compressed folder and let you view the files contained
within, but if you attempt to extract them (either explicitly or by
dragging and dropping) you get an error message that suggests that the
compressed volume is corrupted. Once you "Unblock" the zip file then
everything is fine. The number of support calls caused by this must be
huge.
Click to expand...
 
Ahhh haaa, yes that was the post I was thinking about!!
Thanks Ken (and Rick) for the great assist!
I have now saved the information in my collection.

Ken, any chance we can get Microsoft to make a KB
article on this? I would imagine we will only see more
of these posts when people start migrating to XP SP2.

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.

--

Ken Snell
<MS ACCESS MVP>


Jeff Conrad said:
Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.
Click to expand...
Click to expand...
 
Possibly... but I'll need to be able to repro it somehow so that I can
submit specific info to MS for it, and so far I've not been able to see this
behavior.

If anyone can post some information about what you specifically did to
create this error (how you put the file on your hard drive, where it came
from, the type of file, etc.), then I'll see if we can get that info into a
KB article.


Jeff Conrad said:
Ahhh haaa, yes that was the post I was thinking about!!
Thanks Ken (and Rick) for the great assist!
I have now saved the information in my collection.

Ken, any chance we can get Microsoft to make a KB
article on this? I would imagine we will only see more
of these posts when people start migrating to XP SP2.

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.

--

Ken Snell
<MS ACCESS MVP>


Jeff Conrad said:
Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.

--
Jeff Conrad
Access Junkie
Bend, Oregon

I sent the database to someone else who doesn't have access to
anything
on
our network and he was able to open it with no problem. It seems to
be
either Windows XP or Office XP SP3, which are unique to me.

Steve

Hi Steve,

As I mentioned, this is really not my area of expertise.
The only thing that comes to my (limited) mind is that
the file uses some table links to a network share????
That's just a guess though. Can your colleague confirm
or deny that?

--
Jeff Conrad
Access Junkie
Bend, Oregon

Thanks, I did see your response to an earlier post to a similar
question.
These links do not relate to opening a database on a local
harddrive.

Steve

Hi Steve,

This is outside my area of expertise, but see if these links
help:

You receive an error message when you try to open an Access
2002 database from a Web Server:
http://support.microsoft.com/?id=810582

Intranet site is identified as an Internet site when you use an
FQDN or an IP address:
http://support.microsoft.com/?id=303650

--
Jeff Conrad
Access Junkie
Bend, Oregon


I am trying to open an Access database sent to me by a
colleague.
I
get
the
following error message:

"MS Access cannot open this file.

"This file is located outside your intranet or on an untrusted
site.
MS
Access will not open the file due to potential security
problems.

"To open this file, copy it to your machine or to an accessible
network
location."

The error msg makes no sense, since the file is on my local
machine.

I'm using MS Office XP Pro. SP3 and Windows XP Pro SP2.

Any suggestions?


Steve Kushubar
Click to expand...
Click to expand...
Click to expand...
 
Rick - does this occur only when the Windows XP SP2 firewall is running? or
in all cases? I'm not running Windows default firewall, and am wondering if
that is why I don't see this behavior?


--

Ken Snell
<MS ACCESS MVP>

Rick Brandt said:
Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.
Click to expand...

This is just another "well intended" screw up on MS part. My
understanding of how this feature is *supposed to work* is that you get a
warning about the file, but along with the warning is the option to open
the file "if you are sure about its organ". Choosing that option then
removes the block from the file. Instead you get this very badly worded
message and are not offered any information about what you are supposed to
do that is actually helpful (or even accurate).

Zip files are worse. If you send a Zip file to someone with SP2, XP will
treat it as a compressed folder and let you view the files contained
within, but if you attempt to extract them (either explicitly or by
dragging and dropping) you get an error message that suggests that the
compressed volume is corrupted. Once you "Unblock" the zip file then
everything is fine. The number of support calls caused by this must be
huge.
Click to expand...
 
Also note if you're running Windows Firewall or not.

--

Ken Snell
<MS ACCESS MVP>

Ken Snell said:
Possibly... but I'll need to be able to repro it somehow so that I can
submit specific info to MS for it, and so far I've not been able to see
this behavior.

If anyone can post some information about what you specifically did to
create this error (how you put the file on your hard drive, where it came
from, the type of file, etc.), then I'll see if we can get that info into
a KB article.


Jeff Conrad said:
Ahhh haaa, yes that was the post I was thinking about!!
Thanks Ken (and Rick) for the great assist!
I have now saved the information in my collection.

Ken, any chance we can get Microsoft to make a KB
article on this? I would imagine we will only see more
of these posts when people start migrating to XP SP2.

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.

--

Ken Snell
<MS ACCESS MVP>


Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.

--
Jeff Conrad
Access Junkie
Bend, Oregon

I sent the database to someone else who doesn't have access to
anything
on
our network and he was able to open it with no problem. It seems to
be
either Windows XP or Office XP SP3, which are unique to me.

Steve

Hi Steve,

As I mentioned, this is really not my area of expertise.
The only thing that comes to my (limited) mind is that
the file uses some table links to a network share????
That's just a guess though. Can your colleague confirm
or deny that?

--
Jeff Conrad
Access Junkie
Bend, Oregon

Thanks, I did see your response to an earlier post to a similar
question.
These links do not relate to opening a database on a local
harddrive.

Steve

Hi Steve,

This is outside my area of expertise, but see if these links
help:

You receive an error message when you try to open an Access
2002 database from a Web Server:
http://support.microsoft.com/?id=810582

Intranet site is identified as an Internet site when you use an
FQDN or an IP address:
http://support.microsoft.com/?id=303650

--
Jeff Conrad
Access Junkie
Bend, Oregon


I am trying to open an Access database sent to me by a
colleague.
I
get
the
following error message:

"MS Access cannot open this file.

"This file is located outside your intranet or on an untrusted
site.
MS
Access will not open the file due to potential security
problems.

"To open this file, copy it to your machine or to an accessible
network
location."

The error msg makes no sense, since the file is on my local
machine.

I'm using MS Office XP Pro. SP3 and Windows XP Pro SP2.

Any suggestions?


Steve Kushubar
Click to expand...
Click to expand...
Click to expand...
 
I believe that this MS KB article covers this issue:

Description of how the Attachment Manager works in Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?scid=kb;en-us;883260

--

Ken Snell
<MS ACCESS MVP>

Jeff Conrad said:
Ahhh haaa, yes that was the post I was thinking about!!
Thanks Ken (and Rick) for the great assist!
I have now saved the information in my collection.

Ken, any chance we can get Microsoft to make a KB
article on this? I would imagine we will only see more
of these posts when people start migrating to XP SP2.

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.

--

Ken Snell
<MS ACCESS MVP>


Jeff Conrad said:
Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.

--
Jeff Conrad
Access Junkie
Bend, Oregon

I sent the database to someone else who doesn't have access to
anything
on
our network and he was able to open it with no problem. It seems to
be
either Windows XP or Office XP SP3, which are unique to me.

Steve

Hi Steve,

As I mentioned, this is really not my area of expertise.
The only thing that comes to my (limited) mind is that
the file uses some table links to a network share????
That's just a guess though. Can your colleague confirm
or deny that?

--
Jeff Conrad
Access Junkie
Bend, Oregon

Thanks, I did see your response to an earlier post to a similar
question.
These links do not relate to opening a database on a local
harddrive.

Steve

Hi Steve,

This is outside my area of expertise, but see if these links
help:

You receive an error message when you try to open an Access
2002 database from a Web Server:
http://support.microsoft.com/?id=810582

Intranet site is identified as an Internet site when you use an
FQDN or an IP address:
http://support.microsoft.com/?id=303650

--
Jeff Conrad
Access Junkie
Bend, Oregon


I am trying to open an Access database sent to me by a
colleague.
I
get
the
following error message:

"MS Access cannot open this file.

"This file is located outside your intranet or on an untrusted
site.
MS
Access will not open the file due to potential security
problems.

"To open this file, copy it to your machine or to an accessible
network
location."

The error msg makes no sense, since the file is on my local
machine.

I'm using MS Office XP Pro. SP3 and Windows XP Pro SP2.

Any suggestions?


Steve Kushubar
Click to expand...
Click to expand...
Click to expand...
 
It also appears to be superficially discussed in Windows XP Help. Open Help
from Windows Explorer and search on the keyword
attachment

It will display a few topics about email attachments and how to unblock via
the file icon.


--

Ken Snell
<MS ACCESS MVP>

Ken Snell said:
I believe that this MS KB article covers this issue:

Description of how the Attachment Manager works in Windows XP Service Pack
2
http://support.microsoft.com/default.aspx?scid=kb;en-us;883260

--

Ken Snell
<MS ACCESS MVP>

Jeff Conrad said:
Ahhh haaa, yes that was the post I was thinking about!!
Thanks Ken (and Rick) for the great assist!
I have now saved the information in my collection.

Ken, any chance we can get Microsoft to make a KB
article on this? I would imagine we will only see more
of these posts when people start migrating to XP SP2.

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ken Snell said:
From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.

--

Ken Snell
<MS ACCESS MVP>


Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.

--
Jeff Conrad
Access Junkie
Bend, Oregon

I sent the database to someone else who doesn't have access to
anything
on
our network and he was able to open it with no problem. It seems to
be
either Windows XP or Office XP SP3, which are unique to me.

Steve

Hi Steve,

As I mentioned, this is really not my area of expertise.
The only thing that comes to my (limited) mind is that
the file uses some table links to a network share????
That's just a guess though. Can your colleague confirm
or deny that?

--
Jeff Conrad
Access Junkie
Bend, Oregon

Thanks, I did see your response to an earlier post to a similar
question.
These links do not relate to opening a database on a local
harddrive.

Steve

Hi Steve,

This is outside my area of expertise, but see if these links
help:

You receive an error message when you try to open an Access
2002 database from a Web Server:
http://support.microsoft.com/?id=810582

Intranet site is identified as an Internet site when you use an
FQDN or an IP address:
http://support.microsoft.com/?id=303650

--
Jeff Conrad
Access Junkie
Bend, Oregon


I am trying to open an Access database sent to me by a
colleague.
I
get
the
following error message:

"MS Access cannot open this file.

"This file is located outside your intranet or on an untrusted
site.
MS
Access will not open the file due to potential security
problems.

"To open this file, copy it to your machine or to an accessible
network
location."

The error msg makes no sense, since the file is on my local
machine.

I'm using MS Office XP Pro. SP3 and Windows XP Pro SP2.

Any suggestions?


Steve Kushubar
Click to expand...
Click to expand...
Click to expand...
 
Hi Ken,

Well that looks perfect!
Thanks for the additional information.
Filed away for future use.

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ken Snell said:
It also appears to be superficially discussed in Windows XP Help. Open Help
from Windows Explorer and search on the keyword
attachment

It will display a few topics about email attachments and how to unblock via
the file icon.


--

Ken Snell
<MS ACCESS MVP>

Ken Snell said:
I believe that this MS KB article covers this issue:

Description of how the Attachment Manager works in Windows XP Service Pack
2
http://support.microsoft.com/default.aspx?scid=kb;en-us;883260

--

Ken Snell
<MS ACCESS MVP>

Jeff Conrad said:
Ahhh haaa, yes that was the post I was thinking about!!
Thanks Ken (and Rick) for the great assist!
I have now saved the information in my collection.

Ken, any chance we can get Microsoft to make a KB
article on this? I would imagine we will only see more
of these posts when people start migrating to XP SP2.

--
Jeff Conrad
Access Junkie
Bend, Oregon

From a post by Rick Brandt just recently:

If he has Serveice Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or
being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.

--

Ken Snell
<MS ACCESS MVP>


Hi Steve,

Well this is most peculiar isn't it?
I recall a post on this where someone solved the issue and posted
the steps they took. For the life of me I cannot seem to find that
post now! It does appear to be Windows XP and Office XP related
from the posts I have read.
I'll keep digging.

--
Jeff Conrad
Access Junkie
Bend, Oregon

I sent the database to someone else who doesn't have access to
anything
on
our network and he was able to open it with no problem. It seems to
be
either Windows XP or Office XP SP3, which are unique to me.

Steve

Hi Steve,

As I mentioned, this is really not my area of expertise.
The only thing that comes to my (limited) mind is that
the file uses some table links to a network share????
That's just a guess though. Can your colleague confirm
or deny that?

--
Jeff Conrad
Access Junkie
Bend, Oregon

Thanks, I did see your response to an earlier post to a similar
question.
These links do not relate to opening a database on a local
harddrive.

Steve

Hi Steve,

This is outside my area of expertise, but see if these links
help:

You receive an error message when you try to open an Access
2002 database from a Web Server:
http://support.microsoft.com/?id=810582

Intranet site is identified as an Internet site when you use an
FQDN or an IP address:
http://support.microsoft.com/?id=303650

--
Jeff Conrad
Access Junkie
Bend, Oregon


I am trying to open an Access database sent to me by a
colleague.
I
get
the
following error message:

"MS Access cannot open this file.

"This file is located outside your intranet or on an untrusted
site.
MS
Access will not open the file due to potential security
problems.

"To open this file, copy it to your machine or to an accessible
network
location."

The error msg makes no sense, since the file is on my local
machine.

I'm using MS Office XP Pro. SP3 and Windows XP Pro SP2.

Any suggestions?


Steve Kushubar
Click to expand...
Click to expand...
Click to expand...
 
Back
Top