jm.hwsn
jm.hwsn at gmail.com
Wed Sep 29 13:26:56 CDT 2010
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 >