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

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
> 



More information about the AccessD mailing list