What is the max size for an Access database before it starts bogging down?

Is this a rhetorical question?  A homework assignment?

What is the database design (?split?)?  Over what kind of network?  Network 
speed/NIC speed/setting?  On what type of PCs, with how much RAM?  Which 
version of Access?

Using what table structure?  With how many records?  With what indexing?

"...bogging down" during what kind of operations?  ?Data entry?  ?Reports? 
?Queries?  ?Forms opening?

One man's meat is another's poison ... what would "bogging down" mean to 
you?

Specific descriptions generally lead to specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"jkjmwilliams" <jkjmwilliams@discussions.microsoft.com> wrote in message 
news:97384E18-4546-4CEF-BB9D-9FA9A901E02C@microsoft.com...
> What is the max size for an Access database before it starts bogging down? 

On Fri, 28 Dec 2007 15:33:00 -0800, jkjmwilliams
<jkjmwilliams@discussions.microsoft.com> wrote:

>What is the max size for an Access database before it starts bogging down?

The maximum size, period, is 2 GByte (as described in Help... Specifications).

The max size before it starts "bogging down" depends on a hundred or so
factors, such as the sizes of the key tables, the quality of the table design
(indexing, neither too much nor too little), form design, optimization of VBA
code, frequency of compaction and decompilation, user tolerance for delay (is
15 second response cause for whoops of delight? is 0.5 seconds intolerably
slow? I've seen both reactions), and on and on...

             John W. Vinson [MVP]