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