>Good question - its in 7 tables now, which with indexes is 14 files. I was hoping I could just ship it with one database file for easier installation issues.
Having a native engine that is flexible as FoxPro's is a much better choice than trying through some sort of interop to get to sqlLite or even Sql Compact is not even a contest in my opinion. Part of the reason you're using VFP I'd hope is BECCAUSE of the native data engine.
Stick the files into a seperate folder to minimize the impact of file pollution and call it a day - you'll be much happier in the long run using native tables for a small app than anything that'll require remote commands or ODBC. Plus you probably have to install DB drivers on install machines...
+++ Rick ---
>
>
>>>Anyone have any experience using VFP and sqlite? I have a small app (7 tables), and something bigger than sqlite seems like overkill.
>>>
>>>If so, suggestions would be appreciated.
>>
>>Then why not VFP Native DB?