Software

Ask something
Discussion Locked

Access database

0 helpful
3 replies

by borg7of9

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can anyone tell me what the limit is in size (for example 10 meg) for an access97 database and would it be the same in Access2000.

Also is there a limit in the number of records?

3 replies

by dklippert

The max size of an Access97 db is 1 gig
Access 2000/2002 has a limit of 2 gigs, but linked tables can increase the capacity up to the limits of the storage area.
There is no limit to the number of records per se.
It depends on the complexity of the db etc.

This discussion is closed to new replies.