Forum Discussion
Access: remote access, sharing, OneDrive, etc.
Leonel GUZMAN If you move the back end from an Access accdb to a hosted SQL Server database, which could be Azure as well as one of a number of other hosting services, you can continue to use the same Access Front End. No need to create a new interface.
That DOES require some design changes in Access in some cases because there are traditional approaches in Access that don't work well in other environments. You'll also find some other modifications may be required. Overall, though, it works very well.
You can find a lot of basic information here.
This presentation has been around for a long time, but is still relevant.
- Leonel GUZMANJun 17, 2020Brass Contributor
George Hepworth Thank you!
In fact, I haven't prepared the database yet, and I have a bit of time (need it in January next year), so I'll explore using Azure.
Thank you again
lg