You keep talking about corruption with VFP tables. It's not due to the tables, but due to one of two problems:
1) Poor application architecture. Using direct access to the tables increases the possibility of data corruption. But architecting your application to use less direct methods and use of the FLUSH command solves these problems.
2) External issues. These are mostly out of your control. Bad routers, frequent power interruptions, and other issues can cause corruption. One additional thing here. If you have poor application architecture, users turning off the computer or killing your application through task manager can also cause corruption issues.
Moving to SQL Server is not a solution. It's simply putting a band-aid over existing problems.
>Has anyone used sql ce. Is there any help available on this topic.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer