Along with all the other suggestions, you might want to have a look at DB40 -
www.db40.comIt's free if used under gpl, and there's a charge for commercial non-gpl use. I haven't tried it out yet, but there are a couple of videos, and it looks pretty interesting.
>Hi All
>
>Were converting a VPF desktop application to .Net
>The old application lives and dies on VFP's Rushmore technology for fast data retrieval from .dbf's ranging in size from 350MB to 1.8GB
>
>So what options are there for a fast LOCAL database engine ?
> SQL Server Express has too big a Footprint and the 4Gb database limit is a issue.
> VistaDB looks like a good option but what's it 's performance on large tables like ?
>
>
>Your recomendations would be most appreciated.