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