SQL CE is not a complete database it does not have functions like LEFT() also.
I have decided to use SQL Express & SQL Standard for Desktop software.
I will continue using Foxpro database for Flash drives.
>It's your app and your decision. I hope you make the right decision, and wish you good luck. It would be very nice to read a report about your experience with changing the database engine, and whether that solved your problems or not.
However, you miss my main point completely, namely that you have a problem somewhere in your design, and you should fix it. As many others here have written, corruption is usually caused by badly written software. You live in the hope that adding another database can remove your problem, and you may be right. But your problem will not be fixed because you add the other application, but because you must change your code to work with this other database. These changes would be more or less the same changes as you would make to work with dbfs anyway. My take is that after switching to SQL syntax, your problems would go away also with dbfs.
Good luck, and I mean it. :-)
Aman
-------
Lets fly away to the Land where there is Love & Peace