Hi Bill,
I doubt that the error has anything to do with the table not showing in the list.
The error means that there's value stored in one of rows that does not fit the field definition. Check
Re: Provider cannot determine value Thread #
1257211 Message #
1257226, for example.
Did you try to run query aganst other 'hidden' tables?
>
>I installed the latest provider, no help
>
>Although I couldn't see the table in the list, I ran a query on one of the missing tables and got this error:
>
>
>>>
>Server: Msg 7341, Level 16, State 2, Line 1
>Could not get the current row value of column '[comaxvfp]...[icitem02].specgrav' from the OLE DB provider 'VFPOLEDB'. The provider cannot determine the value for this column.
>OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IRowset::GetData returned 0x80040e21: Data status returned from the provider: [COLUMN_NAME=specgrav STATUS=DBSTATUS_E_UNAVAILABLE]].
><<<
>
>the specgrav column is N(9,5) and all values = 0.
>
>I noticed that another missing table has a UDF in the index and the UDF is not in the folder with the tables, so that one is undertandable.
--sb--