Database Will Not Open by Double-Click

[Guest]

We have several databases in various folders, but all folders and files have the same read/write permissions, etc. Most databases are opened by double-clicking the mdb file (or a short cut to it) with no problem, but for some of the databases Access opens but will not open the database, giving the error message:
"MS Access cannot open this file. This file is located outside your intranetor on an untrusted site. MS Access will not open the file due to potential security problems. To open the file, copy iy to your machine or an accessible network."
The file is already on the local machine (in fact it is on the SBS 2003 server, and I am logged on as Administrator, but still the same problem). I CAN open it by double clicking the mdb or short cut to it from another computer on the network!
ALso odd, is that I can use "file open" from within Access, and there is no problem, but this is not the way we wish to work.
Why does this problem happen at all, why does it happen to just some of the databases, and how do I fix it?

 

[Wayne Morgan]

There is an article that may explain this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;810582

Another possibility is a problem I've seen occur with the symptoms you've
described, but not with the error message you've described. Usually when
there is a error opening a file of a certain type when it works in one
folder but not another is because there are spaces in the name of the path
or file for the ones that don't work. The reason this is a problem is that
the information in the File Types dialog isn't correct. To get to this
dialog, open My Computer and go to Tools|Folder Options and click on the
File Types dialog. Scroll down to the mdb file type and highlight it. Click
the Advanced button, then Open in the lower window and click the Edit...
button.

"Application used to perform action:" should read
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /NOSTARTUP "%1"

Adjusting, of course, for the actual path to Msaccess.exe on your computer.

"DDE Message:" should be
[SetForeground][ShellOpenDatabase "%1"]

The problem usually occurs when the %1 characters don't have quotes around
them. This causes the paths and file names with spaces to not work.

--
Wayne Morgan
Microsoft Access MVP

We have several databases in various folders, but all folders and files

have the same read/write permissions, etc. Most databases are opened by
double-clicking the mdb file (or a short cut to it) with no problem, but for
some of the databases Access opens but will not open the database, giving
the error message:

"MS Access cannot open this file. This file is located outside your

intranetor on an untrusted site. MS Access will not open the file due to
potential security problems. To open the file, copy iy to your machine or an
accessible network."

The file is already on the local machine (in fact it is on the SBS 2003

server, and I am logged on as Administrator, but still the same problem). I
CAN open it by double clicking the mdb or short cut to it from another
computer on the network!

ALso odd, is that I can use "file open" from within Access, and there is

no problem, but this is not the way we wish to work.

Why does this problem happen at all, why does it happen to just some of

the databases, and how do I fix it?