Hello!
currently we have a split FE BE access database on the main location while on the second location we are using windows remote/anydesk to connect to a virtual machine on the main location to use access_fe. More or less we are 10 users working on the database but sometimes the second location experience huge lags/delays (i think net overload).
So i was thinking about using an sql server/azure server to lower the net load and by so improving the latency, but i read on the net that it not always improve the experience and sometimes it can be even slower. So i was wondering what would be a good solution to connect ms access to multiple location
currently we have a split FE BE access database on the main location while on the second location we are using windows remote/anydesk to connect to a virtual machine on the main location to use access_fe. More or less we are 10 users working on the database but sometimes the second location experience huge lags/delays (i think net overload).
So i was thinking about using an sql server/azure server to lower the net load and by so improving the latency, but i read on the net that it not always improve the experience and sometimes it can be even slower. So i was wondering what would be a good solution to connect ms access to multiple location