I have created and maintained a database in Access for a veterans organization over the last 11 years. As I approach 80 years old, I am concerned about long-term maintenance of this database. Access does not seem to be used much here in New Hampshire. I have been considering conversion to the web, hopefully a format much more maintainable in the long run. The database is quite complex, with 70+ tables, 660 queries, 100 forms and lots of code. I have been playing with various PhP application builders, with limited success. None of them seem the deal with complex master-detail relationships very well.
Anyway, what I am looking for is thoughts on alternatives that I might consider. I need some new ideas, or discussion of possible approaches.
Any contributions would be helpful!