<filename> could not be opened. (Not Found).

[Isis]

Dear FM DB Meisters,

A DB i am working with has a file reference which points to a file (eg "olddb") that is usually not there since the file reference is to deal with upgrading the file. There are 3 table occurances that use the file reference. In the upgrade script there is a test if a table exists in the file reference (using isvalid(table_occurance::somefield)) to see if the upgrade should import any records found, otherwise "olddb" doesn't have it to import.

Totally unrelated (pun intended) if the "olddb" file is not there, when a sort by the user is performed, one gets the message:

"olddb could not be opened. (Not Found)".

If the "olddb" file is there, no message is displayed.

I searched the forums for "could not be opened. (Not Found)" and did not get any help that addressed this situation.

Does anyone have a clue as to why FM is giving this message? There are NO calculation fields which use these tables nor any other references to these tables through the 3 table occurances other than testing if isvalid() in the upgrade script. I would think that this should keep FM from testing table occurance is pointing to an actual file or not. But maybe i am wrong.

Is there another way to test if a table exists in a DB file that will not trigger this message from FM if the DB file is not there?

Peace,

Dan