I have 2 versions of the same database. One uses M/S Access and is installed on stand alone laptops, the second is web based MySQL/HTML/PHP. The database is simple ie a single table with cuirrent 8000 records with 32 fields/record which is expanding at around 1000 records per year.
What I would love is a stand alone solution that can be browser based, i.e. Internet connection not required. Is it possible to create a web based version using my HTML/PHP skills where the data is stored encrypted in a flat file, and only the search results being returned unencrypted, and it all being packaged in an installer.
I can imagine there being more security issues, and whilst the data has no financial value to anyone ( it is very specialised scientific data) it has taken a lot of effort to compile it.
If this concept is possible with modest programming skills, I would be greatful if you could take a few minutes to reply suggesting what approaches I should investigate especially on the data encryption/unencryption side.
Thanks in advance for all those that reply. I will make this post solved once I have some ideas to work on.