Maximum

[A Baker]

Newbie here . . .

Tow quick questions:
1) What's the maximum number of records one can put into
Access 97 (or 2000)?

2) What's the maximum size an Access database can be (in
megabytes)?

Thanks

 

[John Vinson]

Newbie here . . .

Tow quick questions:
1) What's the maximum number of records one can put into
Access 97 (or 2000)?

There is no explicit maximum. The size of the database is the
limitation. In practice, the biggest table I'm aware of as being in
routine use has over 100,000,000 records; I'd start seriously
considering client-server over a few million.

2) What's the maximum size an Access database can be (in
megabytes)?

1024 MByte in A97, 2048 MByte in later versions. See the online help
under "Specifications" for more details.

 

[Guest]

Thanks!

A. Baker

-----Original Message-----


There is no explicit maximum. The size of the database is the
limitation. In practice, the biggest table I'm aware of as being in
routine use has over 100,000,000 records; I'd start seriously
considering client-server over a few million.


1024 MByte in A97, 2048 MByte in later versions. See the online help
under "Specifications" for more details.


.