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

Steve,

I have noticed that once in a while our Access Front-End seems to load
slowly (15-20 seconds).

I was just curious if this might be caused by its size (20 Meg). 

We could split the Front-End into multiple files, but this would be a
last resort.

Thanks for the help,
Brad


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

Brad,

Gary has given you the answer re 2 GB.

Just wondering - what is the reason for your concern?  In my experience,

backend database files can sometimes get pretty meaty, but the size of
the 
frontend is not normally an issue.  The biggest one I have is only about
30 
MB (after compacting), and I can't really imagine one ever getting too
big.

Regards
Steve

-----Original Message----- 
From: Brad Marks
Sent: Tuesday, September 28, 2010 9:10 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] "Rule of Thumb" for size of Access "Accdb" file 
(FrontEnd)

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.


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