This article is an attempt to understand the performance of MS Access on a remote desktop environment or on SharePoint Server
Not all users of MS Access can afford to make use of the application on-premises, thus leaving them with the choice of either using it on a SharePoint Server or on any other remote desktop environment. But before you choose to make a move towards either of the two, you need to understand how do they stack up or how does Access perform over a remote environment. If you have already used MS Access, you would have an idea about what all it does, what all it involves, and how does it make your work easier.
Incompatibility of SharePoint and VBA
Before you proceed to move towards using Access on SharePoint, you also need to know that it does not support VBA. This limits the number of operations that a user can perform with Access on SharePoint, as a majority of complex operations performed in the application make use of VBA. In the absence of VBA, your scope of activity gets reduced. And if you think this limitation is exclusive to Access only, then you are wrong, because Excel too involves VBA. So using Access with SharePoint is probably not a good choice.
Access Web Apps
Since support for VBA was crucial and working without it on online environments was becoming a challenge, MS released Access web apps, wherein VBA was replaced with Macros. However, this too did not go down well with regular users of the application as the scope offered by these macros was very limited as compared to that offered by VBA.
Using MS Access over Cloud
As compared to the performance of Access on SharePoint or the Access web app, using the application on remote desktop environment works way better. If you are putting your application on the cloud, you will be able to get access to your system desktop online, without necessarily having the system with you. It allows you to remotely access your own desktop, which makes things a lot easier.
This works well not just for the databases you have on your system, but also for the mission-critical databases that you need to access at all times and are looking for a safe place to migrate them. A cloud environment not only makes your data available at all times but also ensures its safety, provided you make use of a secure cloud provider.
Using Access on Remote Desktop Environments
Deploying an Access application on a remote desktop environment can work well for a lot of people and companies. It saves you from the restrictions of SharePoint or the inability to use VBA, along with the limitations of using Macros in Access web apps. If migrating your Access application is something you have been planning to do for a while, then using MS Access on a remote desktop environment is a very reliable option. They not only stack well but also ensure an all-time efficiency and availability and can be quickly used to tackle incidents of Access damage
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf repair and excel recovery software products. For more information visit www.datanumen.com