Michelle,
When you say the database is open and current, I assume you mean you tested it for this at the time of the error (select suspend option)? If so, what happens if you just type "USE MyTable" at the command window while suspended?
Mark
>I have a combo-based class that has the SQL in the init of the class. There's a custom property of the class that tells the name of the table to get the data from.
>
>This class worked fine in Tripsoft. Now I'm using it in a new app, and it tells me it can't find the table.
>
>The table is in the database, which is open and the current database. The table, as well as the database, is in the path.
>
>I don't have the table in the DE because there are a _lot_ of look-up tables and I'd rather just have the select open it up. I have no idea why it can't find it.
>
>Any ideas?
>
>Thanks,
>
>-Michelle
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.