Unwelcomed Protection

[Earl Anderson]

In WinXP & A2002, whenever I attempt to open some 'mbd' files that I've
unzipped, downloaded or received as an email attachment, Access opens with a
blank screen and a message stating:
"Microsoft Access cannot open this file.
This file is located outside your intranet or an untrusted site.
Microsoft Access will not open this file due to potential security problems.
To open this file, copy it to your machine or an accessible network
location."

I then copied the file to some folder on my hard drive and tried to open it
again, getting the same message. The message appears with most mdbs I did
not create myself. (Some outside mdbs will open fine, some won't-displaying
the message.)

I then tried to go to 'Tools' to seek a 'Security' remedy, but with the
blank screen, all menu choices are 'grayed out' except 'Wkgp Admin', 'User
Grps' & 'Encrypt DB'.

Is this uninvited and unwelcomed protection a 'WinXP thing' or a 'A2002
thing' and does anyone have a suggestion as to how to overcome it?

Thx...
Earl

[Gord]

On Aug 3, 6:17 am, "Earl Anderson" <[e-mail]:

In WinXP & A2002, whenever I attempt to open some 'mbd' files that I've
unzipped, downloaded or received as an email attachment, Access opens with a
blank screen and a message stating:
"Microsoft Access cannot open this file.
This file is located outside your intranet or an untrusted site.
Microsoft Access will not open this file due to potential security problems.
To open this file, copy it to your machine or an accessible network
location."

I then copied the file to some folder on my hard drive and tried to open it
again, getting the same message. The message appears with most mdbs I did
not create myself. (Some outside mdbs will open fine, some won't-displaying
the message.)

I then tried to go to 'Tools' to seek a 'Security' remedy, but with the
blank screen, all menu choices are 'grayed out' except 'Wkgp Admin', 'User
Grps' & 'Encrypt DB'.

Is this uninvited and unwelcomed protection a 'WinXP thing' or a 'A2002
thing' and does anyone have a suggestion as to how to overcome it?

I believe it's an "IE7 thing".

In IE7, choose

Tools Internet Options

Click the "Security" tab. Select the "Local intranet" zone. Click the
"Sites" button. Clear the checkbox for "Automatically detect intranet
network".

See if that helps.

[John Welch]

You should be able to right click on the file icon, go to properties,
and then somewhere you should see something like "unlock file".

Earl Anderson wrote:

In WinXP & A2002, whenever I attempt to open some 'mbd' files that I've
unzipped, downloaded or received as an email attachment, Access opens with a
blank screen and a message stating:
"Microsoft Access cannot open this file.
This file is located outside your intranet or an untrusted site.
Microsoft Access will not open this file due to potential security problems.
To open this file, copy it to your machine or an accessible network
location."

I then copied the file to some folder on my hard drive and tried to open it
again, getting the same message. The message appears with most mdbs I did
not create myself. (Some outside mdbs will open fine, some won't-displaying
the message.)

I then tried to go to 'Tools' to seek a 'Security' remedy, but with the
blank screen, all menu choices are 'grayed out' except 'Wkgp Admin', 'User
Grps' & 'Encrypt DB'.

Is this uninvited and unwelcomed protection a 'WinXP thing' or a 'A2002
thing' and does anyone have a suggestion as to how to overcome it?

Thx...
Earl

[Gord]

On Aug 6, 1:41 pm, John Welch <[e-mail]:

You should be able to right click on the file icon, go to properties,
and then somewhere you should see something like "unlock file".

Really? When I right-click an MDB file under WinXP and choose
"Properties" I don't see any such option. Can you be more specific?

Earl Anderson wrote:

In WinXP & A2002, whenever I attempt to open some 'mbd' files that I've
unzipped, downloaded or received as an email attachment, Access opens with a
blank screen and a message stating:
"Microsoft Access cannot open this file.
This file is located outside your intranet or an untrusted site.
Microsoft Access will not open this file due to potential security problems.
To open this file, copy it to your machine or an accessible network
location."

I then copied the file to some folder on my hard drive and tried to open it
again, getting the same message. The message appears with most mdbs I did
not create myself. (Some outside mdbs will open fine, some won't-displaying
the message.)

I then tried to go to 'Tools' to seek a 'Security' remedy, but with the
blank screen, all menu choices are 'grayed out' except 'Wkgp Admin', 'User
Grps' & 'Encrypt DB'.

Is this uninvited and unwelcomed protection a 'WinXP thing' or a 'A2002
thing' and does anyone have a suggestion as to how to overcome it?

Thx...
Earl

[Rick Brandt]

Gord wrote:

On Aug 6, 1:41 pm, John Welch <[e-mail]:

You should be able to right click on the file icon, go to
properties, and then somewhere you should see something like
"unlock file".

Really? When I right-click an MDB file under WinXP and choose
"Properties" I don't see any such option. Can you be more specific?

It is only there on "some" files. Those that XP recognizes as having been
downloaded or recieved as EMail attachments. Files copied from say, a USB drive
or CD would not have the property attached to them and thus would have no [
Unlock ] button.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Gord]

On Aug 6, 8:48 pm, "Rick Brandt" <[e-mail]:

Gord wrote:

On Aug 6, 1:41 pm, John Welch <[e-mail]:

You should be able to right click on the file icon, go to
properties, and then somewhere you should see something like
"unlock file".

Really? When I right-click an MDB file under WinXP and choose
"Properties" I don't see any such option. Can you be more specific?

It is only there on "some" files. Those that XP recognizes as having been
downloaded or recieved as EMail attachments. Files copied from say, a USB drive
or CD would not have the property attached to them and thus would have no [
Unlock ] button.

Okay, thanks Rick (and John). I hadn't encountered the "Unblock"
button before.