I assume you are using Access 2000.
This message can occur because the Windows file association for .Mdb files
specifies DDE on the command line, for some strange reason, and Access has
been set up to ignore DDE requests. In this circumstance, the message should
really read something like "Cannot process DDE request."
Two solutions:
1) Change the windows file association for .Mdb files. Go into Windows
Explorer, Tools, Folder Options, File Types, click on .Mdb, click the button
for Advanced, Edit, and remove the DDE parameters completely. (Why Microsoft
sets up a default .Mdb association for Access 2000 using DDE is a complete
mystery to me.)
2) Set up Access to respond to DDE requests. From the debug window, or in
code, run the following:
Application.SetOption "Ignore DDE Requests", False
- Steve
"L Mehl" <me*********@cyvest.com> wrote in message
news:qx******************@newsread2.news.pas.earth link.net...
Hello --
Fairly often, but not always, when I start the app by clicking the mdb or
an icon set up to start it, I get the message
"Cannot find the file 'c:\path...\dbname.mdb' [or one of its
components]...."
and then the app starts, as if there were no problem.
The mdb is located correctly. I assume that all required libraries are
available, because the app runs OK.
Does anyone have experience with this message and have a solution for it?
Thanks for any help.
Larry Mehl
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.669 / Virus Database: 431 - Release Date: 4/26/2004