Access Database maxium size

[Pam]

What is the maxium size of a database can Access handle
before shutting down. I have a access database that's
growing quickly and need to know when I exceeded Access
limits.....

 

[Cheryl Fischer]

For Access 97 and older, the max is 1GB; for Access 2000 and newer, it is
2GB. This limitation can be avoided by splitting the database into a
front-end (containing all Queries, Forms, Reports, Macros, Modules and local
use tables) and a back-end (containing all shared data tables).

hth,

 

[Howard Brody]

.... and make sure you compact it on a regular basi


----- Cheryl Fischer wrote: ----

For Access 97 and older, the max is 1GB; for Access 2000 and newer, it i
2GB. This limitation can be avoided by splitting the database into
front-end (containing all Queries, Forms, Reports, Macros, Modules and loca
use tables) and a back-end (containing all shared data tables)

hth

-

Cheryl Fischer, MVP Microsoft Acces
Law/Sys Associates, Houston, T