How big can an Access table be?

[Doomster]

I have Office 2000. I am creating a database that will record stats
from football, basketball, and hockey games. One table will contain
info about a game. The game could be a football, basketball, or hockey
game. There will be at least 2700+ records per season. Each record
will have more than 20 fields each. The table will have games from
varous seasons so I can see it containing very many records (40000+).

Is there a maximum size to the number of records an Access table can
have?

And is there a maximum size that a table can be?

# of records X # of fields = SIZE. Is there a max limit to SIZE?

Thanx,
Doomster

 

[Allen Browne]

40k records is small in Access.

It will handle hundreds of thousands of records with ease, millions of
necessary.

 

[Joseph Meehan]

I have Office 2000. I am creating a database that will record stats
from football, basketball, and hockey games. One table will contain
info about a game. The game could be a football, basketball, or
hockey game. There will be at least 2700+ records per season. Each
record will have more than 20 fields each. The table will have games
from varous seasons so I can see it containing very many records
(40000+).

Is there a maximum size to the number of records an Access table can
have?

And is there a maximum size that a table can be?

# of records X # of fields = SIZE. Is there a max limit to SIZE?

Thanx,
Doomster

No max number of records. The max size of the database is 1 or 2 gig
depending on the version. Noted that if you delete records, they are not
really deleted and size of the database made smaller until the database is
compacted.

 

[Doomster]

"The max size of the database is 1 or 2 gig depending on the version"

A clarification question....

When you refer to the "max size of the database", are you talking about
the max size of a table or the max size of the database (the .mdb file
with all the tables, forms, queries, etc.)???

 

[Rick Brandt]

"The max size of the database is 1 or 2 gig depending on the version"

A clarification question....

When you refer to the "max size of the database", are you talking
about the max size of a table or the max size of the database (the
.mdb file with all the tables, forms, queries, etc.)???

The MDB.

 

[Joseph Meehan]

"The max size of the database is 1 or 2 gig depending on the version"

A clarification question....

When you refer to the "max size of the database", are you talking
about the max size of a table or the max size of the database (the
.mdb file with all the tables, forms, queries, etc.)???

Max size of the database.