>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.
>
SWAG - do the fields failing to appear via VFP SPT share a common datatype? 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?
>The DBA has indicated that there is nothing different that stands out about the user's rights to those tables.
>