If the tables were created with 7, 8, or 9 and contain any of the database or table enhancement added in those versions (new fields, DBC events, etc), the ODBC will not work. Use the OLE DB Provider.
>T have vfp 7, 8, and 9 on my PC at work. I would like to document the VFP 0 application. I used the Generic ODBC driver because I did not see the VFP ODBC driver. I get a message say some freatures will may not be availabe (or some thing like that, I am doing this form memory). What I would like to do is reverse emgineer or import the VFP tables. If possible it would be nice to create ET diagrams. Is any of this possible.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer