Jim Lawrence
accessd at shaw.ca
Wed Jul 7 21:43:12 CDT 2010
I have heard your story before and have held a couple of clients back from upgrading until I can transfer their BE to MS SQL or SQL Express. The last app that I migrated from a MDB BE to SQL Express, took about a month, in dribs and drabs, to re-write, with SPs and using ADO-OLE connection. (Real men and women do not use ODBC so we will not use that four letter euphemism, in polite company, again.) ;-) The new app now runs about twice as fast as the old 2003 FE/BE even using the retarded Access2007 FE. This fall or early spring I will be moving the FE to .Net and that will be an end to it. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: Wednesday, July 07, 2010 1:01 PM To: Access Developers discussion and problem solving 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