>You use the ODBC Administrator to set up a DSN using the VFP ODBC driver. Then in Access, when you add a table, you set up a link to the VFP tables using the DSN you created. Access will give you the list of VFP tables to pick from. Access will read the field info for each selected table. You are going to be mostly at the mercy of the "front end" for how back-end information is retrieved and served up to you.
>
>Access is more of a graphical interface to create stuff. Where in VFP, you can do things in code or graphically just as easily. You will have a hard time setting up anything via code in Access.

I know how to do it in Access. I used Access as an example. Forget Access. Here is what I want. From within a third party ODBC tool I want to manually send a select statement to VFP thru the ODBC DSN to retrieve information about the tables in the VFP .dbc that the DSN is linked to. What should that SQL statement be?