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.

I want to avoid the mind-numbing prospect of 500+ clicks.

Thanks,

Henry