Clever Geek Handbook

Replacing the access database

Does anyone know of an access database replacement, ideally open source. The group I work with sometimes is looking for a replacement database where they need to change the real SQL as little as possible. Their application is VB6 / COM.

+1


source to share


6 answers


SQL Server Express is the best option. It's free to use. It uses standard SQL, you will need to modify any of the queries that use MS Access functions.



+8


source


Once again, the question is so poorly formulated that there is no way to answer.

Is the word "Access" used here to describe a situation where MDB is used for data tables and what is all that needs to be replaced?

OR

Does the use of the word "Access" mean that there is a complete Access application that is used as the front of the database?

If it is the former, then it is not an Access database, but a Jet database and the answers offered so far are satisfactory.



If this is the latter, then none of the answers address the issue of front-end tools for building applications. If this is a question, then you're out of luck, as there is nothing even remotely comparable to Access in the open source world (and in my opinion, most likely it won't).

But it would be helpful to ask a clearer question, using the terminology correctly:

  • ACCESS is an application with which you can create the front end of a database application.
  • JET is the database engine and is the default data store for Access.

When you only have data tables in your Access database, then it is just a Jet database (since you have no UI objects in your MDB) and you must refer to it as a Jet database. Using the word "Access" for a data-backed MDB (even if you used Access to create it) will just confuse things.

+3


source


I think SQLite is always worth mentioning for these types of scenarios.

+1


source


You can look at the OpenOffice base.

I tried this a while ago when it first came out and it felt terribly slow and it didn't feel complete either.

But it's free and open source: o)

0


source


OpenOffice.org offers a free open source database application called Base. Either that or I suggest SQL Server Express as well.

0


source


What I see most often is "a database that I can install by copying files without having to install software (services, drivers, etc.)".

What's missing in the Access database they want to replace? The options will be limited to the answer to this question.

0


source






More articles:


All Articles