良好的自由选择MS访问 [英] Good Free Alternative To MS Access

问题描述

考虑在微软平台上开发一个轻量级桌面数据库应用程序的需要。

它可以做到相当容易与MS Access，但我想能够将其分发给其他人，我不想支付运行时许可证。

要求：

• 轻松发布给他人


• 没有运行时许可问题

注意事项和候选人：

• 基于OpenOffice套件。我的担心是它的稳定性。


• MySQL +使用C ++或Python编写自订资料库程式码，或任何看起来像一个相当沉重的解决方案。
b
$ b

---





另请参阅：开源报告引擎





---





---





@Schnapple





Bruceatk对我的想法的打击;它不是那么多的数据库引擎，因为我想要的其他细节Access带来的聚会。好的形式设计器，漂亮的报告引擎等。但你提出了一个非常好的点安装的足迹。我曾经考虑过，但我没有做出任何坚决的决定，我将采取这种方式，无论如何。





---





@Remou，

/ p>



没有我不知道MS Access 2007运行时是免费的;感谢您指出了这一点。最后一次我想调查它（我不记得什么时候）我认为这是一个相当昂贵的许可证运行时，因为我认为他们试图卖给公司的IT部门。





感谢所有回应的人;我完全不知道你所有指出的其他选项。

解决方案

SQLlite ，

Firebird < a>，

VistaDB （非免费），

和 SQL Server精简版（不是Express）
$ b





另一个想法：虽然原来的问题确实询问桌面数据库，但可能有些人会在这里寻找一个数据库来使用网站。请务必记住，这些都是在进程中的数据库，因此很少适合在网上使用。如果你想构建一个网站，你真的需要一个数据库服务器引擎，如MS SQL，Postgresql，MySQL，Oracle或他们的弟弟。同时，这些服务器引擎很少适用于单用户桌面应用程序。




Consider the need to develop a lightweight desktop DB application on the Microsoft platforms.

It could be done fairly easily with MS Access but I'd like to be able to distribute it to others and I don't want to pay for a runtime license.

Requirements:

• easy distribution to others
• no runtime licensing issues

Considerations and Candidates:

• Base from the OpenOffice suite. My concerns were around its stability.
• MySQL + writing custom DB code in C++ or Python or whatever seems like a rather heavy-handed solution.

Question: What are the low cost or free database alternatives to MS Access?

---

See Also: Open Source Reporting Engines

---

---

@Schnapple

Bruceatk kind of hit on what I'm thinking of; it's not so much the DB engine as I want the other niceties that Access brings to the party. The nice form designer, the nice reporting engine etc. But you do raise a very good point about the installation footprint. I had considered that but I've not made any firm decisions about which way I'm going with this yet anyway. It'll probably be something fairly lightweight anyway and a small installation footprint would definitely be a plus.

---

@Remou,

No I was unaware that the MS Access 2007 runtime is free; thanks for pointing that out. The last time I'd bothered to investigate it (I don't remember when it was) I think it was a fairly expensive license for the runtime because I think they were trying to sell it to Corporate IT departments.

And thanks to everyone else who responded as well; I was completely unaware of those other options you all pointed out.

解决方案

SQLlite,
Firebird,
VistaDB (not free),
and SQL Server Compact Edition (not Express)
all come to mind.

Another thought: while the original question does ask about desktop databases, its likely some people will land here looking for a database to use with a web site. It's important to remember that these are all in-process databases, and as such are rarely if ever appropriate for use on the web. If you want to build a web site, you really need a database server engine, like MS SQL, Postgresql, MySQL, Oracle, or their brethren. At the same time, those server engines are rarely if ever appropriate for a single-user desktop application.

这篇关于良好的自由选择MS访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！