I have devloped access application and using by more than 30 members at a time. i placed the backend file in the share drive and frontend in the PCs desktop by linking the tables to the backend file.it is very slow...How to spead up the application ?? Is there is any other way could i use...for multiuser application .....
Access is never good for multi-user with more than about 10 users! MS say: use SQL server. Of course, it all depends on the complexity of the app, the amount of data, transaction rate etc. You can also try putting the backend on a "real" server (15K rpm SCSI or sSCSI disc, Xeon CPU) and give it as much RAM as you can afford (at least 4GB) then you might get reasonable performance. If you can't do it any other way & a licence for MS SQL Server is out of the question, use MySQL as a backend: you can make Access clients talk to it as there is a free Access driver for it. You can even run MySQL under windows: you don't need Linux (although it will run faster under Linux). Setting it up is fairly easy and it will outperform an Access backend by at least an order of magnitude, if not 2 or 3 :)
118 views
Usually answered in minutes!
thank you daverh....and applolize for late response....
how to write a query to display sum of two weeks information
using MSAccess
×