1

I am looking for an alternative to MS Access. A simple tool that you can design a front-end for the user to be able to connect to database and enter data.

Background;

currently I am using Access as a front-end Form to allow users to scan in data into the database. As the number of records increases it is getting longer to refresh the form and enter the next set of data.

Requirements;

Simple and fast design. validation of data entered

Thanks

1

I would take a look at LibreOffice Base:

  • Free
  • Cross Platform
  • Database Back-ends: MySQL/MariaDB, Adabas D, MS Access, PostgreSQL, JDBC & ODBC
  • Fast - Yes
  • Data Validation - Yes both with form properties & basic macros, (you can also use python as discussed here).
0

You can use:

  • PostgreSQL
  • Django Admin Interface

You define the tables via models in python code. Then you only add a few lines of python and you have got a great and robust solution.

I guess the first days to learn these new things will be hard, but you won't regret it. The community is great. The django docs are great.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.