Search code examples
c#ms-accessportable-database

Microsoft Access Database instead of SQLite or Local Database


Does a Microsoft Access Database is a possible solution to this question? SQLite seems to be exactly what I want but I cannot make it work in the .NET framework 4.0.

I was thinking about using a Microsoft Access Database but I don't know if when deploying my application the database is going to be portable?

Do users need to have Microsoft Access installed in their computers if I plan to deploy my application with a Microsoft Access Database?

In case all this is possible and I decide to use a Microsoft Access DB where will I place the database?
As a resource and extract it when installing it?


Solution

  • I haven't had problems using SQLite using with the provided .NET assemblies.. As an alternative you could try using Microsoft's SQL Server CE, which is a lightweight database designed for deploying to clients. I don't see why you'd use Access db instead of either of the other two..