jm.hwsn
jm.hwsn at gmail.com
Wed Sep 29 14:32:45 CDT 2010
Thanks, Doug. I did convert the BE to 2000 format and it did speed up. My next step is to keep it connected. Thanks, Jim -------------------------------------------------- From: "Doug Murphy" <dw-murphy at cox.net> Sent: Wednesday, September 29, 2010 1:41 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] "Rule of Thumb" forsizeofAccess "Accdb"file(FrontEnd)> For this app the speed is reasonable. The back end is in 2000 format, i.e. > mdb. Network speed can have a real impact. Keep the database connected as > has been discussed here many times. For info look in the archives. > > I have another client who specified 2007 and that database was slowwwwww. > It > was even slow to develop in, forms took forever to open in design view. > The > person who did the original design used attachment fields. It was my > assumption that these were the cause of much of the lag, but I never took > the time to prove this. The customer wanted it faster so we put the back > end > in SQL Server, changed the attachment fields to binaries and the thing > really moves now. I suggested using the file system for the attachment > files > but the customer was adamant that they would be in the database. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jm.hwsn > Sent: Wednesday, September 29, 2010 11:27 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] "Rule of Thumb" forsizeofAccess "Accdb" > file(FrontEnd) > > How is the speed over the network with A2007? > What are you using for the BE? > > I have a Access 2007 front end on each user's desktop; with an Access 2007 > BE. With only one or two people using it - it is slow.... > > The contract says..."Access 2007" only. It is painfully slow. I surmise > it's the network because even accessing some Word or Excel files it's > slow. > > What could be done to speed it up? > > Thanks, > Jim > > -------------------------------------------------- > From: "Doug Murphy" <dw-murphy at cox.net> > Sent: Wednesday, September 29, 2010 11:22 AM > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] "Rule of Thumb" for sizeofAccess > "Accdb"file(FrontEnd)> We have a client in Access 2007 with a 33 Meg front > end and it runs fine >> with the front end on each users computer. When we got involved with >> this application they were sharing from the server over a not very >> fast network and it really was slow. >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby >> Sent: Wednesday, September 29, 2010 7:24 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] "Rule of Thumb" for size ofAccess "Accdb" >> file(FrontEnd) >> >> > I've never had any problems with FE's of any size that I could >> > trace >> just >> > to the factor of size. >> >> Me either. OTOH I have never seen a database much above 25 megabytes >> even though I have some with LOTS of forms and queries. >> >> John W. Colby >> www.ColbyConsulting.com >> >> On 9/29/2010 8:29 AM, Jim Dettman wrote: >>> >>> As I said, I never could put any real rhyme or reason to it. >>> Seems to be one of those myths that have just been floating around. >>> >>> As Gary suggested, it may have come about from developers who >>> don't bother to do a split design or do it and *still* leave the FE >>> on the server to be shared rather then deploying it out to the clients. >>> >>> I've never had any problems with FE's of any size that I could >>> trace just to the factor of size. >>> >>> Jim. >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks >>> Sent: Tuesday, September 28, 2010 4:33 PM >>> To: Access Developers discussion and problem solving >>> Subject: Re: [AccessD] "Rule of Thumb" for size of Access "Accdb" >>> file(FrontEnd) >>> >>> Jim, >>> >>> Any ideas on why some think that anything over 25 or 30 MB is too big? >>> >>> Some folks must have run into some issues for this idea to be >>> floating around. >>> >>> Thanks, >>> Brad >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim >>> Dettman >>> Sent: Tuesday, September 28, 2010 10:32 AM >>> To: 'Access Developers discussion and problem solving' >>> Subject: Re: [AccessD] "Rule of Thumb" for size of Access "Accdb" >>> file(Front End) >>> >>> >>> None really although I've found that some think anything over 25 >>> or 30MB is "too big" for some reason. Never been able to put a rhyme >>> or reason to that. >>> >>> Jim. >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks >>> Sent: Monday, September 27, 2010 4:11 PM >>> To: Access Developers discussion and problem solving >>> Subject: [AccessD] "Rule of Thumb" for size of Access "Accdb" file >>> (Front >>> End) >>> >>> Are there any general rules for how large an Access 2007 "Accdb" file >>> can be? >>> >>> This would be the "Front End" part of an Access Application, with the >>> data stored in the "Back End". >>> >>> If necessary, we could split the Front End into more than one Accdb >>> file. >>> >>> Thanks, >>> Brad >>> >>> >> -- >> 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 >> > -- > 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 >