Ms Access - backend speed Inprovment

[Number11]

Hi,

I am trying to gain the understanding on how changing these settings can improve the speed..

 

[Minty]

None of them will make much difference I think unless you have network issues.
Have you altered them to see on a test database?

A hardwired gigabit network connection will make the biggest difference, as will a good network infrastructure, assuming a local backend datafile.

 

[Number11]

None of them will make much difference I think unless you have network issues.
Have you altered them to see on a test database?

A hardwired gigabit network connection will make the biggest difference, as will a good network infrastructure, assuming a local backend datafile.

Thanks we now have many users connected through VPN, so we are experiencing slowness caused by home working and VPS.

 

[Minty]

VPN is not a great way to connect to Access as you have discovered.
Unless you have a solid gigabit connection between the user and the host it will be painful to use.

With many users I would implement a remote desktop solution, this will mean the end-user logs in to a per-user dedicated RDP or RDP application shortcut that opens on a remote machine that is local to the server network. Each user has their own folder.

Speed will then not be an issue, but your RDP server will need sufficient resources to cope with the number of concurrent users.

 

[NauticalGent]

With many users I would implement a remote desktop solution, this will mean the end-user logs in to a per-user dedicated RDP or RDP application shortcut that opens on a remote machine that is local to the server network. Each user has their own folder.

We use CITRIX with a SharePoint BE. It isn't ideal but the speed and reliability is much better.