Hi,
I'm current working on a ASP.NET application that uses a VFP 9 database as the backend. I also need to access data from a VFP 6 database. Unfortunately, I cannot upgrade the VFP 6 database, because the application that it's used for does not support VFP 9.
I have a couple of questions about this cross version data access.
1) Can I use the VFP 9 OLEDB provider to read data from the VFP 6 database or would I have to stick with ODBC?
2) Can I use VFP 6 to insert records directly (using native VFP code rather than via ODBC or OLEDB) into the VFP 9 tables without messing it up?
It's been a while (3 years at least) since I've done anything "big" with VFP, so I'm a little out of touch. Any help would be greatly appreciated. Thanks --Tom