[AccessD] "Rule of Thumb" for size of Access "Accdb" file(FrontEnd)

Gary,

Thanks for the help.  

I have read a lot of info about Access, but I don't think that I have seen much in the realm of
"Production Deployment" guidelines.  

Brad  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Tuesday, September 28, 2010 3:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] "Rule of Thumb" for size of Access "Accdb" file(FrontEnd)

It might be more of a gut feeling kind of thing. As a front end
expands it does increase the amount of data needing to be shot up and
down the LAN connection. Smaller = faster. Since Access has no
"database server" so to speak, everything has to happen on the client
machine so there is a lot of LAN traffic. Keeping the front end local
helps that a lot and many developers will work out a system to copy a
central copy from the server to a local hard drive with a batch file
or something similar prior to starting the application up.

GK

On Tue, Sep 28, 2010 at 3:32 PM, Brad Marks <BradM at blackforestltd.com> wrote:
> 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
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.