Hi I have an application i created for multiple users to use over a network and have run into a serious speed issue when access data (read/write).
the front end application is being used on the workstations via MSRuntime and the backend tables are all ACCDB files (which i believe is the most current).
I used to have 10 users running ( a few years a go mind you) without any impact to speed - were were all flying!
now If there is only 1 user on the network the speed is great but as soon as 2 or more users log in the lag time is terrible (front end is always showing "calculating" in the lower left hand corner of the screen).
I thought perhaps the network was slow and have just recently upgraded everything with a 1 GB 48 port switch and a high performance NAS unit. Basically i have tons of performance built into the network now. I feel i can reasonably check off network for issues as the cause of the slow running speed.
I'm wondering now if MSAccess has a max user over the network problem? How many users is considered reasonable?
The backend tables are split between 5 .accdb files for a total of approx 100mb of backend data (each table no larger than 30mb)
The last thing i can think of (or actually wish not to think of - ha) is the program itself.... If i have to start looking for areas in the application causing the slowness i really don't know where to start. Any suggestions?
appreciate any incite you can offer in my nightmare....
tks,