Our organization has a small MySQL database that tracks when customers had their propane tanks checked. We can then query the information on demand for our insurance company, which ultimately is the point of the database. 2 users access it on our Intranet and conduct the data entry. In its current state, it doesn't have much functionality and is cumbersome at best.
I'm wanting some redundancy and ultimately to improve on the product. What I'm thinking is that I could import the information into MS Access, and then provide a data entry option utilizing SharePoint. Is this a viable solution, or would you suggest something else? I'm at the pre-planning stage right now and would value any input. I did read that they are sun-setting InfoPath, so I'm not sure I want to put in my eggs in the proverbial basket long term with that.
I would value any feedback, thank you!