opening database from shortcut causes problem

[cook59]

I recently restored Win XP and Office XP to their original state and then
applied all updates.

When I now open an Access mdb, it opens and then a Windows message appears:
"Windows cannot find 'mdb name'.... Make sure you typed the name
correctly....".

I have tried creating new shortcuts get the same results. Shortcuts to open
mde files do not have this problem.

Any ideas?

 

[Tom Wickerath]

Try the following. However, I don't know if it will help in your case.

1.) Open Windows Explorer
2.) Click on Tools | Folder Options...
3.) Select the File Types tab. Wait for the list to be populated. Scroll
down the list until you find "MDB Microsoft Office Access Application"
<---text for Access 2003. The text shown will likely be different for an
earlier version of Access. Select this entry.
4.) Click on the Advanced... button.
5.) Select the Open action and click on the Edit... button.

Here are the settings that I see on my machine. On the second entry, for
"Application used to perform action:", verify that you have this, including
the surrounding quotes, at the end of the line: "%1"

Action:
Open

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


Use DDE ---> Checked

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

Application:
Msaccess

DDE Application Not Running:
[SHELLNOOP]

Topic:
ShellSystem



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[cook59]

Tom, thanks for the reply. My settings were the same as yours.

However, I looked at the settings for MDE filetypes (for which shortcuts are
working) and I found that "DDE Message" and "DDE Application Not Running"
were both blank. I deleted those settings for MDB filetype and I no longer
have the shortcut problem. So the root cause seems to be related to those
settings.

Try the following. However, I don't know if it will help in your case.

1.) Open Windows Explorer
2.) Click on Tools | Folder Options...
3.) Select the File Types tab. Wait for the list to be populated. Scroll
down the list until you find "MDB Microsoft Office Access Application"
<---text for Access 2003. The text shown will likely be different for an
earlier version of Access. Select this entry.
4.) Click on the Advanced... button.
5.) Select the Open action and click on the Edit... button.

Here are the settings that I see on my machine. On the second entry, for
"Application used to perform action:", verify that you have this, including
the surrounding quotes, at the end of the line: "%1"

Action:
Open

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


Use DDE ---> Checked

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

Application:
Msaccess

DDE Application Not Running:
[SHELLNOOP]

Topic:
ShellSystem



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

I recently restored Win XP and Office XP to their original state and then
applied all updates.

When I now open an Access mdb, it opens and then a Windows message appears:
"Windows cannot find 'mdb name'.... Make sure you typed the name
correctly....".

I have tried creating new shortcuts get the same results. Shortcuts to open
mde files do not have this problem.

Any ideas?

 

[Tom Wickerath]

I'm glad to read that you got the problem solved. It's strange that the same
settings didn't work, but I'd go with what works!


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________