How big can an Access table be?

  • Thread starter Thread starter Doomster
  • Start date Start date
D

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
 
40k records is small in Access.

It will handle hundreds of thousands of records with ease, millions of
necessary.
 
Doomster said:
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
Click to expand...

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.
 
"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.)???
 
Doomster said:
"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.)???
Click to expand...

The MDB.
 
Doomster said:
"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.)???
Click to expand...

Max size of the database.
 
Back
Top