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

Jim Dettman jimdettman at verizon.net
Wed Sep 29 07:29:25 CDT 2010


  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

-- 
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




More information about the AccessD mailing list