>>I have an MDB file but don't know what tables it has. What is the most effective way to convert the entire Access database to VFP?

(I don't have Access so I can't even open the MDB file).

>>Thank you.

Do you have VFP9 Beta Installed? If yes, just create a connection and you can browse the tables from the access file. From there you know what fields it has.

Using the file MDBtoVFP conversion tool is not 100%. I ran a problem when I used it. It cannot handle tables with empty records..

You can download the Beta Version of VFP9 at the MSDN if you don't have.

Your last resort will be creating an ODBC and remote views, then browse the views one by one and use copy to command... which is time consuming.