Is a Microsoft access database embedded as a sqlite database is?

Question

1.00/5 (1 vote)

See more:

I'm struggling with understanding the differences (if they exist) between an Access database (.mdb file) and a SQLite database (.sqlite file).

1) How are they working (ie implementing the database system functionnalities)?
In the case of SQLite, I guess it's the SQLite dll which is processing your data.
For Access, I dunno !
2) Are they similar, or do you need Access on your computer to use an .mdb file in a C++ application?

Edit:
3) Because an Access database needs Jet or ACE, can we say that an Access database file is "embedded"? What is the difference with, say, a PostgreSQL database?
4) Is Access really using Jet, which is deprecated ? Even Access 2016 ? It sounds weird to me...

Thanks !

What I have tried:

Looking around on the internet.

Posted 31-Jan-18 0:58am

SheepSpeech

Updated 1-Feb-18 22:29pm

v5

Add a Solution

3 solutions

Solution 1

Nope. SQlite and Microsoft Access are quite different beasts. See for instance: SQLite is a Self Contained System[^].

Posted 31-Jan-18 1:02am

CPallini

Solution 3

MS Access and SQLite are very different indeed but Microsoft SQL Server does offer embeded solutions as well: [^]

...but there are so many different versions its hard to say which one is best and technically most similar to SQLite ...

Posted 31-Jan-18 4:42am

Dirk Bahle

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2018-01-31T01:09:00

Solution 2

Quote:
Are they similar, or do you need Access on your computer to use an .mdb file in a C++ application?

No - you can use an .db without Access instead, though you will need the ACE or JET engine installed.
See Google: .mdb file in a C application - Google Search[^] because the exact details will depend on the type of your app - CLR/.NET apps are very different from MFC for example.

Posted 31-Jan-18 1:09am

OriginalGriff

Comments

SheepSpeech 31-Jan-18 10:59am

Thank you. After my searches, could you answer some new questions I had in mind :
3) Because an Access database needs Jet or ACE, can we say that an Access database file is "embedded"? What is the difference with, say, a PostgreSQL database?
4) Is Access really using Jet, which is deprecated ? Even Access 2016 ? It sounds weird to me...

OriginalGriff 31-Jan-18 11:33am

3) No. An embedded resource is internal to the application EXE file, and an embedded database would be ... difficult to modify without annoying anti-virus products.
4) Depends what version of Access the DB file is: early ones are best kept with Jet (which only works in 32 bit), ACE is preferable because it supports all formats and sizes. There are still apps being developed using JET to maintain backwards compatibility with other apps using it.