You really need to verify what the user has SELECT privileges on. The only way a user will get some but not all columns of an Oracle table is if some one has granted them SELECT privileges on specific columns in a table. While this is possible, I think most of the time privileges are granted on the entire table, not just certain columns.

Go to the user and have them connect with Access using their Oracle user name and password. Then check what they get with VFP. Make sure the the results are with SPT instead of a remote view [since a remote view can be designe to retrieve specific columns].

>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