By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,276 Members | 1,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,276 IT Pros & Developers. It's quick & easy.

How big can an Access table be?

P: n/a
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

Jan 16 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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" <do******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
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

Jan 16 '06 #2

P: n/a
Doomster wrote:
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.

--
Joseph Meehan

Dia duit
Jan 16 '06 #3

P: n/a
"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.)???

Jan 18 '06 #4

P: n/a
Doomster wrote:
"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.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jan 18 '06 #5

P: n/a
Doomster wrote:
"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.

--
Joseph Meehan

Dia duit
Jan 18 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.