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?

Yes, You can use mdb file. But I would prefer sqllite or sql compact. — VikciaR
– VikciaR, Commented May 29, 2011 at 5: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
– pickypg, Commented May 29, 2011 at 5:29

filip-fku · Accepted Answer · 2011-05-29 05:18:47Z

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

answered May 29, 2011 at 5:18

filip-fku

3,2651 gold badge23 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tono Nam Over a year ago

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

David-W-Fenton · Accepted Answer · 2011-05-30 23:01:42Z

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.

answered May 30, 2011 at 23:01

David-W-Fenton

23.2k4 gold badges48 silver badges59 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:34:35Z

0

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

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered May 29, 2011 at 5:33

Tono Nam

36.5k86 gold badges330 silver badges496 bronze badges

Collectives™ on Stack Overflow

Microsoft Access Database instead of SQLite or Local Database

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related