Take the 2-minute tour ×  I'm upgrading an inventory system for
a jewllery store that was originally built with MS Access. The
application stores items, customers, vendors, and displays data
about items stored. Reporting tool should be considered to
generate reports for items in a printable format.  The system
should be built in C#, but I've not made the decision yet for
the database engine I should use for this application. What do
you suggest?. I thought of SQLite, but I need to keep in mind
that migration items from the old database to the new updated
one is a must. And since it was originally built with MS Access.
Should I just stick with MS Access and build my application with
it?.  Edit: This is a single user system.  share|improve this
question Linq is cool by the way. –  Hamish Grubijan Feb 18 '10
at 1:05  6 Answers 6  up vote 4 down vote accepted  For single-
user desktop apps in a Microsoft ecosystem, consider SQL Server
Compact Edition rather than the full-fledged server product.
Here's the relevant