Thanks to those that tried, I FIXED IT.
Not really, I removed all tables and views after copying the view code and copying the stored procedures to a text file. Recreated the dbc, added the tables back and recreated the views from the text file. It now runs in vfp6.
Extreme Programming = Plan -> Design -> Code -> Test