1

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?

Community
  • 1
  • 1
Tono Nam
  • 34,064
  • 78
  • 298
  • 470
  • 1
    What is the problem that you have with SQLite? – Alex Aza May 29 '11 at 05:09
  • Yes, You can use mdb file. But I would prefer sqllite or sql compact. – VikciaR May 29 '11 at 05:17
  • See filip-fku's answer. I have never been happy when using Microsoft Access on any project. Never. It will burn you later if you choose to go this route in terms of rewriting queries for other database engines. – pickypg May 29 '11 at 05:29

3 Answers3

1

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

filip-fku
  • 3,265
  • 1
  • 21
  • 19
  • or maybe I am missing other assemblies. I have not been able to work with .NET Framework 4.0 and SQLite . Any suggestions on what assemblies I need in order to make it work will be nice – Tono Nam May 29 '11 at 05:22
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.

David-W-Fenton
  • 22,871
  • 4
  • 45
  • 58
0

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

Community
  • 1
  • 1
Tono Nam
  • 34,064
  • 78
  • 298
  • 470