Access Database maxium size

  • Thread starter Thread starter Pam
  • Start date Start date
P

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.....
 
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,
 
.... 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
 
Back
Top