Question posted 2009 ยท +5 upvotes
Question: We’ve started a project for a customer, which includes what would normally be done with a database.
However, the customer wants no database installed, since it’s only a little application. We however intend to reuse the code for a larger project, which will use a database.
The problem is all the server side code will be different if I’m using XML or SQlite or Access.
I’m tending towards SQlite, but I don’t know. Would adding the database in an MS-Access file be a better solution? If I would put it into an access database, does the customer need MS-Access installed or only the MSFT MDAC ? If I use the Access DB, will that run under Linux with Mono, too, or is there no MDAC replacement ?
Accepted answer +8 upvotes
I would consider using NHibernate, you can hook it up to SQLite, but can upgrade later to a full database later without needing to change much code. If you’re not keen on this, I would use SQLite directly over XML files.
Top ms-access Q&A (6)
- How can I modify a saved Microsoft Access 2007 or 2010 Import Specification? +31 (2008)
- OleDbCommand parameters order and priority +28 (2009)
- Is there an equivalent to the SUBSTRING function in MS Access SQL? +26 (2009)
- What do I need to read Microsoft Access databases using Python? +25 (2009)
- MS Access library for python +24 (2009)
- is there any replacement of Access? +21 (2009)
ms-access solutions on this site
.