Access Database via remote VPN Access
Like many other probably are right now, some colleagues and I are working remotely from home, and accessing our network resources remotely via a secure VPN.
However, accessing anything that uses a Microsoft Access Database, for example, the E3 database(s), from a central shared network location is unbearably slow and in some cases not even functional.
Is there a suggested way to make a shared database more functional for remote use? Our database has shared edit rights and various people can make updates that need to be accessible to all people using E3.
Yes I could limit it to only one person to do database work and distribute database updates, but that will bog down the database editor and slow down the other users that are capable of making the edits they need to. So downloading a copy of the database to local machines, while it would be quick, appears impractical, and bandwidth to our company network is not the fastest, only 100mbps up and down among the entire company to use.
Is the best solution trying to convert the access database to a SQL database that could handle the queries much better? Is there some documentation help on doing that conversion? Any drawbacks from converting the access database to a SQL database?
Any other suggestions?