[AccessD] "Rule of Thumb" forsizeofAccess "Accdb" file(FrontEnd)

Doug Murphy dw-murphy at cox.net
Wed Sep 29 13:41:04 CDT 2010


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




More information about the AccessD mailing list