1 and 2 are all fine, but they don't fix the problem. Now I think it is a problem in VFP. I moved the database container into the root and kept all the tables in the subdirectory. That solved the problem.

In the article 229779 mentioned below, it states this error message happened as early as in VFP 3.0. I'm using VFP 9 with SP1. Using the resolutions presented in the article, the problem cannot be solved. I'm surprised and wonder whether I had missed something.

>Try these:
>1. Open the table in question, then Modify Structure. Go to the Table tab and verify that the Database is correct. Close the table.
>
>2. Close All. Open the database exclusive then run Validate Database Recover. This will tell if there are invalid table links.
>
>>
>>I edited the CursorSource property as described in MS KB article 229779. It doesn't solve the problem, though the error message is a little different. After I changed the CursorSource from "table1" to "..\data\table1" (or the full path) by editing scx file, the new error says that it cannot find table1 in the dbc.