Microsoft Access Database instead of SQLite or Local Database

Question

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?

Answer 1

The Jet database engine is installed on every copy of Windows beginning with Windows 2000, so if you use MDB format, you don't have to install anything to have access to a Jet MDB file.

If, however, you use ACCDB format, you'd have to install the ACE.

Answer 2

Filip-fku thanks to your answer I found how to work with SQLite and the .Net framework 4.0 in here

Answer 3

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..