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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)