size of database

[jkjmwilliams]

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

 

[Jeff Boyce]

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

 

[John W. Vinson]

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]