Database Will Not Open by Double-Click

message from =?Utf-8?B?SW1wZXhpcw==?= on 8 May 2004

"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 replied to =?Utf-8?B?SW1wZXhpcw==?= on 9 May 2004

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.

Archived message: Database Will Not Open by Double-Click (Microsoft Access Forms)