How do I use SQL Offline (Local Host) for my Database?

[si_the_geek]

In that case SQL Server CE could well be apt for the main database.

In terms of features it is about the same as Access, but is not prone to the same issues (such as corruption that needs Compact & Repair).

In terms of installation you just need to add 7 DLL's to your installation package.


Another free alternative is SQL Server Express, which has more features (such as support for Stored Procedures), but has a larger/more complex installation.