The languages/technologies are too different. There is no conversion utility.
>Has anyone out there heard of a utility to convert an existing Access 2000 application into Visual Foxpro? I have found a utility on the UT to convert the data, but then there's the forms, code, reports, etc....
>
>It's just that the application we have is so slow.... I'm not a fan of Access to develop applications but we have one here that has been developed and desperately needs moving to VFP. I've just been looking at an SQL Delete to remove duplications -
>
>A VFP table with 87,542 records can remove 54 duplicate records in under 2 seconds.
>We want to remove 78 records from an Access table with 29,415 records well forget it! After a couple of minutes I have to press escape until Access admits defeat and returns control.
>
>The code? Well here it is, not very complex (for Fox that is):
>
>delete from tblSurveyResult where fldResultID in
>(SELECT First(tblSurveyResult.fldResultID) AS fldResultID
>FROM tblSurveyResult
>GROUP BY tblSurveyResult.fldSurveyID, tblSurveyResult.fldTrapID
>HAVING Count(tblSurveyResult.fldTestDate)>1);
>
>So if anyone has any ideas how I can take most of the work out of Access into Fox, then I will be most grateful.
>
>Until then, I'm going to back to hitting my head against the way.
>
>Many thanks
>
>Jason
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer