Also make sure they don't have a table of the same name and same structure except for the missing fields. Check the public synonym for the table and make sure it is pointing to the correct table.

>First off, I'm pretty much a newbie when it comes to ODBC. Here's the problem:
>
>In connecting to an Oracle 7 database with VFP 6 (not sure if client has installed SP's--assuming no), most tables can produce full data sets. However, a small number of tables produce only a subset of the fields when a SQLEXEC(nConnection, "select * from x", "y") is sent to Oracle.
>
>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.
>
>The DBA has indicated that there is nothing different that stands out about the user's rights to those tables.
>
>
>Any ideas???
>
>Thanks,
>
>John