>Thanks, Ed.
>
>>>What I know (or perceive that I know):
>>>These tables can be opened by the same user('s login) in Access with full data and structure appearing.
>
>>SWAG - do the fields failing to appear via VFP SPT share a common datatype?
>
>They appear to all be character fields of varying, relatively short, lengths.
>
>>I'm not Oracle-proficient, but it's one possible explanation. Another thing to
>>examine is the Oracle ODBC/OLEDB version in use by both products; maybe Access
>>is using a different driver, perhaps ADO?
>
>I'll check. I believe they are both using the same driver.
As an experiment, see if you can use ADO from within VFP to pull over a recordset that contains the missing fields.