>>>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.
Hi Jojo,
I did download the vfp 9 beta but have not installed it. Now this may give me an incentive to do it.
Thank you for your suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham