Database size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a maximum size for an Access database? If so, what is it and what
should I do when my database reaches that size?
 
Hi Mary

The maximum size of an Access 97 database is 1 gigabyte, Access 2000 and up the
maximum size is 2 gigabytes

However, because your database can include linked tables in other files, its
total size is limited only by available storage capacity.

Best regards

Maurice St-Cyr

Micro Systems Consultants, Inc.
 
If you're using Access 2000 or newer, the maximum size for an MDB file is 2
GB (it's 1 GB for previous versions).

It's possible to link from one MDB to another, though (through File | Get
External Data), so in theory you could store to whatever the capacity of
your hard drive is (I've heard one story of an installation that linked
together a total of 23 GB). Having said that, though, in general practice if
you're approaching the 2 GB limit, you might want to start looking at a
heavier duty DBMS such as SQL Server or Oracle.
 
Back
Top