是否将Microsoft Access数据库嵌入为sqlite数据库？ [英] Is a Microsoft access database embedded as a sqlite database is?

问题描述

我正在努力理解Access数据库（.mdb文件）和SQLite数据库（.sqlite文件）之间的差异（如果存在）。



1）它们是如何工作的（即实现数据库系统的功能）？

对于SQLite，我猜这是SQLite dll正在处理你的数据。

对于Access，我不知道！

2）它们是否相似，或者你是否需要在你的计算机上使用Access才能使用.mdb文件一个C ++应用程序？



编辑：

3）因为Access数据库需要Jet或ACE，我们可以说Access数据库文件是嵌入式？比如PostgreSQL数据库有什么区别？

4）Access是否真的使用Jet，这是不推荐使用的？即使访问2016？这对我来说听起来很奇怪...



谢谢！



我尝试过：



环顾四周。

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?


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.

推荐答案

不。 SQlite 和 Microsoft Access 是完全不同的野兽。例如，请参阅： SQLite是一个自包含系统 [ ^ ]。

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

Quote：

它们是否相似，或者您是否需要在计算机上使用Access来在C ++应用程序中使用.mdb文件？

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

否 - 您可以使用.db而不使用.db请改为访问，但您需要安装ACE或JET引擎。

请参阅Google： C应用程序中的.mdb文件 - Google搜索 [ ^ ]因为确切的det ails将取决于您的应用程序类型 - 例如，CLR / .NET应用程序与MFC非常不同。

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.

MS Access和SQLite确实非常不同但Microsoft SQL Server确实提供了嵌入式解决方案同样： [ ^ ]



...但是有很多不同的版本很难说哪一个最好，技术上最类似于SQLite ......

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

这篇关于是否将Microsoft Access数据库嵌入为sqlite数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！