henry.dagher@hrsdc-rhdcc.gc.ca wrote:

> I am trying to analyze an undocumented Oracle data model. The DB has been dumped into an Access mdb for me.

>

> Using VFP (of course), I'm trying to read in the names of all the tables (100+) in the mdb so I can programmatically create remote views. My ultimate goal is to scan all fields in all tables in search of data values.

>

> I have created a DB and made a connection to the MDB. What I'm missing is a way to populate an array with the names of the tables in the mdb. Then I can cycle and programmatically create my remote views. The actual search is NOT a problem. I am just struggling with getting the list of tables from the mdb.

SQLTables() is your friend.

SQLColumns() will be your friend, after you make friends with SQLTables()