Dan Waters
df.waters at comcast.net
Fri Nov 12 08:38:30 CST 2010
Hi Jim, I develop exclusively in Access 2003. Some of my customers use Access 2007 and they use my system which has all Access 2003 mdb's. They have not experienced any delay - they would have told me. It sounds as though the slowness comes using Access 2007 files with Access 2007, but using Access 2003 files with Access 2007 still gives good performance. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jm.hwsn Sent: Thursday, November 11, 2010 9:38 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Another assessment....2007 My last contract specifically stated the project would be done in Access 2007 and SQL Server 2005 as the back end. Because the client has procurement issues (it was never approved by the IT department) SQL Server wasn't purchased for the project. ALL development was done strictly in Access 2007. When it was time to split the ACCDB into a FE-BE configuration - the problems began. Over the network it was slow... very slow... even with only one user connected to the BE. Even with a persistent connection it was slow. As an experiment, I downsized the BE to A2000 and it speeded up significantly. However, the project had a requirement that several fields would be able to have Rich-Text formatting. In Access 2007, the Memo field has native RTF. With one ACCDB the database was fast and all the requirements worked well... but the tool developed would eventually have several users connect to the BE simultaneously. After working exclusively with A2007 for a year - I like it. However, I don't recommend it for any application where there is need to have a FE/BE scenario. I did some research and there doesn't seem to be any solution for the slowness with the FE/BE. Even with SQL Server 2005, there seems slowness will be there. Just my experience... take it for what it's worth. Jim -------------------------------------------------- From: "Mark Simms" <marksimms at verizon.net> Sent: Thursday, November 11, 2010 4:26 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: [AccessD] Another assessment....2007 > Well, when it rains, it pours up here in Philly.... > now I am being asking for yet another Access application assessment and > cost > estimate. > I think they are upgrading from AC97....but once again, they want to move > to > AC2007....UGHH.... > > Is there anything I can say of benefit for AC2007 vs. AC2003 other than > the > ability to use the ribbon... > which of course must be toggled on and off if you want to use all of the > screen real estate ? > Is there even one compelling feature of AC2007 ? > > Is there any reason I can't develop totally in 2003/MDB and then just > upsize > it to AC2007 ACCDB ? > The only thing I'm worried about is the "split" (MDE + MDB) front-end / > back-end. > Will each of these separately upsize to AC2007 ? > I am worried I might have to develop in MDB, upsize, and then split. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com