rajeshsarin
Registered User.
- Local time
- Tomorrow, 03:08
- Joined
- Sep 25, 2009
- Messages
- 50
Folks,
I have a Access 2007 database, which has a 45Mb backend that sits on a file server (windows SBS 2008). I have 15 users using windows XP which have their own front end.
When a single user is on the network the average time to execute a query or report is under 1 second. However when all users are online, the average time to execute a query and report increases to just under 10 seconds.
Any suggestions how I can reduce the query processing / reports time on the network? Is this a commonly seen issue?
Regards - Raj
I have a Access 2007 database, which has a 45Mb backend that sits on a file server (windows SBS 2008). I have 15 users using windows XP which have their own front end.
When a single user is on the network the average time to execute a query or report is under 1 second. However when all users are online, the average time to execute a query and report increases to just under 10 seconds.
Any suggestions how I can reduce the query processing / reports time on the network? Is this a commonly seen issue?
Regards - Raj
