Maximum

  • Thread starter Thread starter A Baker
  • Start date Start date
A

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
 
Newbie here . . .

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

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)?
Click to expand...

1024 MByte in A97, 2048 MByte in later versions. See the online help
under "Specifications" for more details.
 
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.


.
Click to expand...
 
Back
Top