How big can an Access table be?

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

re: How big can an Access table be?

40k records is small in Access.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Doomster" <doomster@gmail.com> wrote in message
news:1137393943.517798.104480@o13g2000cwo.googlegr oups.com...[color=blue]
>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[/color]

re: How big can an Access table be?

Doomster wrote:[color=blue]
>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[/color]

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.

--
Joseph Meehan

Dia duit

re: How big can an Access table be?

"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.)???

re: How big can an Access table be?

Doomster wrote:[color=blue]
> "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.)???[/color]

The MDB.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

re: How big can an Access table be?

Doomster wrote:[color=blue]
> "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.)???[/color]

Max size of the database.

--
Joseph Meehan

Dia duit