I need to create a relatively simple database management environment with a secure graphic user interface, including forms, for data entry. In my co What has been used since to fill this need is an Access database file stored on a shared drive, which was made by a partner not me. Several issues are stemming from the fact that the database is locked down for security, so no updates are possible to the interface. I cannot fix any form bugs, and I keep finding them.
What are the best resources to meet my needs?
- data must absolutely be secure
- data integrity is fundamental so I need every entry/edit action by data enterers to be securely stored
- I know Python, SQL and have used Mongo before
-no user including the admin may have backend access to change the data without a trace (like you can in Access)
- I need to be able to produce something very quickly and continue to fix bugs if they occur