Recommendations for single user access Database
I am writing a desktop utility application to manage a small set of data. This application will be used by a singular person so I’d like to keep the database as simple as possible. I am considering XML or SQL Server Compact 3.5 (SQL CE). I am leaning towards SQL CE because it will probably be easier/quicker to develop than XML. Are there any other worthwhile solutions worth considering? Is SQL CE the way to go?
Edit – Here are some more specifics on the data:
- Maybe a half a dozen tables
- No more than 5000 records
- Mostly CRUD operations
- Basic reporting/exporting to excel