I work for a small company (25 employees) 10 of which are database users. We have an internal Access Database we've been using and developing for the last 10 or so years. Needless to say it's quite complex and there's a lot to it.
Access front-end connected to a local MySQL server backend.
With the whole imminent impending Coronavirus shutdown I'm investigating ways to allow my users to work from home.
My first instincts have been to setup remote desktop access and allow users to connect in and use their desktop on their home device. However, I'm concerned about the load on the our connection and that this might ultimately be an extremely frustrating user experience.
With that in mind I have a couple of questions:
1) Is there a quick and easy way to connect an Access front-end to an online back-end so that I can just send each user a local copy of the front-end, connect it to an online service and they all use it locally and seamlessly? We already have various MySQL databases with domains we own but none of my existing providers allow external apps to connect to their databases.
2) Is there another recommended solution to easily convert an MS Access database to an online web-based solution? I am decent enough at PHP, HTML, CSS, MySQL that I could build these all manually but we have 165 tables and so that's a lot of manual development and form building and testing I don't have the time to do so I'm looking for some form of quick import.
3) Any other suggestions given the time and pressure constraints I'm under?
Access front-end connected to a local MySQL server backend.
With the whole imminent impending Coronavirus shutdown I'm investigating ways to allow my users to work from home.
My first instincts have been to setup remote desktop access and allow users to connect in and use their desktop on their home device. However, I'm concerned about the load on the our connection and that this might ultimately be an extremely frustrating user experience.
With that in mind I have a couple of questions:
1) Is there a quick and easy way to connect an Access front-end to an online back-end so that I can just send each user a local copy of the front-end, connect it to an online service and they all use it locally and seamlessly? We already have various MySQL databases with domains we own but none of my existing providers allow external apps to connect to their databases.
2) Is there another recommended solution to easily convert an MS Access database to an online web-based solution? I am decent enough at PHP, HTML, CSS, MySQL that I could build these all manually but we have 165 tables and so that's a lot of manual development and form building and testing I don't have the time to do so I'm looking for some form of quick import.
3) Any other suggestions given the time and pressure constraints I'm under?