rockysmolin at bchacc.com
rockysmolin at bchacc.com
Wed Jul 7 18:39:44 CDT 2010
I'll bet a dollar the downgrade works. You could probably give them all 2003 run times and it would run like a spotted dog as well. ADO or DAO? R Original Message: ----------------- From: Mark Breen marklbreen at gmail.com Date: Wed, 7 Jul 2010 21:00:43 +0100 To: accessd at databaseadvisors.com Subject: [AccessD] Terrible performance like I have never seen before Hello AccessD Friends of Old, I have a customer that is running an large-ish access app. About 50 tables and 10 forms. Some large complex queries. One a standalone machine it runs fast as lightening. They say that in the past it also ran fast on their network. However, they say that since they upgrade the backend and front end to Access 2007, the performance has dropped through the floor. I can see the performance and it is absolutely terrible 30 - 60 seconds to open a form. But now for the interesting bit. It is only slow when the 26 users are using it !!! yes, they have 26 users keying data all day long. I was gobsmacked because while I read about it, I never saw it happening in real life. To Summarise, 26 users - Access 2000 no problem 26 users - Access 2007 dreadfully slow 1 users - Access 2007 no problem. This is pointing to a difference between Access 2007 and multi-user situations but how can I resolve it? I have prepared an mdb file in Access 2000 format for testing when the 26 people come into work in the morning, and if downgrading the BE fixes it, that I am happy, but I do not think it is going to solve my problems. Any idea? thanks for your help Mark -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------------------------------------------------------------- mail2web.com – Enhanced email for the mobile individual based on Microsoft® Exchange - http://link.mail2web.com/Personal/EnhancedEmail