Microsoft has abused Foxpro users horribly. At a government agency, they had several replicated FoxPro databases to run the Air for the Environmental compliance. I had integrated it with MS Access connected to SQL Server.
One weekend, secretly and undocumented, Microsoft added the death of the working ODBC Foxpro driver into some Windows update. This basically shut down the environmental efforts.
Given my limited resources back then, I think my solution was to link tables from SQL Server into Foxpro. Then create views on SQL Server for MS Access.
If memory serves, the efficiency was not that great. Queries were not that efficient and had to be re-written. The data structure on Foxpro was very simple. Hardly any joined tables.
Realizing this isn't what you were looking for as an optional solution, realize that Foxpro has continued to be marginalized by Microsoft. Moving the data into SQL Server might be the best solution. of course,
Foxpro base will complain about the existing forms, macro's, reports and views rewrite.
This becomes a business decision. Does an organization plan a painful time or do they wait until a random event that Microsoft introduces?
A group called codemag claims they have a free vfpconversion analysis tool.
The advertised claim is the tool can help people make the conversion. Of course they also offer assistance for a fee. There are probably others too that offer this service.
I attended the last MS FoxPro Users group meeting in our region about 9 years ago.
The problem mentioned above created the need to keep some experts available. It use to have around 100 dues paying members. They created a non-profit to take donations and manage prizes. The last meeting had six of us. The retired president called to tell us to attend so the club could officially distribute all the prizes and cash as required for a non-profit.
While there was nothing "foxpro" to be given away, I scored Microsoft Office and SQL Server enterprise software and much, much more that night. We called it a wake. We will neither confirm or deny the presence of excellent Scotch during the ceremony.
Please let everyone know if you find a solution. The Internet has many post that share your frustration.
