User is unable to open a new .mde level

  • Thread starter Thread starter Gordon Jones
  • Start date Start date
G

Gordon Jones

I have issued a new .mde level of my program. I download
both the .mde version and a .zip-ped copy, and both test
o.k. Numerous other users have also installed it o.k.

One user gets the following message upon trying to open the
new level:
"Microsoft Access cannot open this file. This file is
located outside your intanet or on an untrusted site.
Microsoft Access will not opotn the file due to potential
security problems. To open file, copy it to your machine
or an accessible network location."

I have tried to get the user to open the program holding
down the shift key in order to check to see if the problem
is associated with the Link Table Manager, but it won't
open for her in that mode either.

I've also tried sending her another copy of the program,
but the results are the same.

She has recently installed SP2 on XP. This is an Access
2002 program.

I'd appreciate any help.

Gordon
 
Hi, Gordon.

Does this problem database have linked tables that are linked using an IP
address (\\123.123.123.1\SharedDir) or a fully qualified domain name
(\\ComputerName.OurDomain.com\SharedDir), instead of the Unified Naming
Convention (UNC) (\\ComputerName\SharedDir) or a hard-coded mapped drive
(T:\SharedDir)?

Those pesky little periods in the path name confuse the "enhanced" security
system.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
No. The front end xyz.mde is installed in c:\xyz, the and
the back end xyz_be.mdb is also installed in c:\xyz. The
Link Table Manager is linked to c:\xyz\xyz_be.mdb. The
application is delivered that way, and updates expect to
find the back end there.

I have also had her send me the .zip package that she
downloaded from my distribution web page, and it checks out
just as it should. It appears that the problem is in her
environment, but she doesn't do anything with it.

GOrdon
 
Hi, Gordon.

How about deadwood? Any linked tables, queries, VBA code, macros,
recordsource properties, or controlsource properties that are no longer used
in the current application, but still reference an external database file
that might use a period in the path name?

Other than that, I'm out of ideas. Perhaps someone else has some advice for
you.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Negative on the outside links. Thanks for the effort.
Incidentally, I owned a 69 Firebird Convertible for a
number of years, eventually gave it to my daughter and
son-in-law who also loved it.
Gordon
 
It turns out that the problem was solved by having the user
add my web site to the Trusted Sites list in Internet
Explorer. Access checks on the source of the program
before opening it, and looks in IE to see that it can be
trusted as a source.
Gordon
 
Hi, Gordon.

Thanks for the update. Glad you got it sorted out.

You mentioned that you solved it by "having the user add my web site," but
I'm wondering what "security issue" requires this. Is your application
signed by a domain-level digital certificate which identifies your domain
name, or does the application include an object that contains a path to your
domain on the Internet, such as a hyperlink on a form? I ask because none
of our clients are currently using digital certificates with MS Office XP,
but some are planning to do so. I'm wondering if it's going to be an issue
for them too, since no links or paths identify our domain name within any of
our MS Office applications.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Hi, Gordon.
Negative on the outside links. Thanks for the effort.

You're welcome. I see in another reply to this thread that you've solved
the problem. Good job!
Incidentally, I owned a 69 Firebird Convertible

That brings back memories! When I was a kid, a college student brought a
'69 Firebird into my step-father's auto shop. When she found out how much
it was going to cost to replace the blown engine, she decided it wasn't
worth it. My step-father offered her $50 for the Firebird because with a
blown engine and a dire need for a paint job, that car's only destination
was going to be the junk yard. This was the day after my mom was in a
rear-end collision with her car, so he already had an engine available. It
cost $500 for the paint job and several days for my step-father to exchange
the engines -- big blocks don't fit easily under the hood of a '69
Firebird! -- my mom had a souped-up hot rod to cruise around in. She loved
it! And a friend-of-a-friend of mine in high school had a '69 Firebird
convertible too, so I have lots of fond memories of driving around in the
Pontiac version of my beloved Camaros (I've owned four Camaros, but never a
Firebird).

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top