Access Not Installed On Our Server!!! 1

[BruceJackson]

We have multiple users using a number of Access databases that are sitting on a central server on my site.

We are having severe speed problems for our remote users - other sites hundreds of miles away.

We do not have Access installed on the server. If we did, could this help to aleviate the network speed problems? I am thinking of queries then being performed on the server and less data travelling through the network?

Thanks for any information you can give.

 

[jrbarnett]

Access itself is a file based database, so installing Access on your server won't make any difference to the performance of the databases.
Using a proper client/server database such as MSDE (a cut down version of SQL Server) which is supplied with Office 97 and XP will allow you to do exactly what you want, but this particular version is limited to about 5 concurrent users.

I would also though check the network performance, is it just Access databases that are slow, or are other things slow as well?
An alternative may be a remote desktop system using Windows Terminal Server or Citrix.

John