[AccessD] "Rule of Thumb" for size ofAccess "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