How much data?

P

Peler Kuda

hi i want to ask about Microsoft Access 2003
how much data can we put in every table that we created?
what is the limit?
 
A

Allen Browne

Theoretically, a table can contain many billions of records, but a database
file is limited to 2 gigabytes.

In practice, if you foresee tables with many millions of records before you
start your database, you might consider a larger database product.
 
A

Albert D. Kallal

The limits is not how many records, but in fact the total size of the
database.

in a2003, the max file size is 2 gig.

A typical name in a mailing list is about 160 characters.

So, if we have 1 million names in the table, then we get:

1000000 x 160 charaters = 160 million characters, or 160 meg

2 gig = 2000 meg

So, you can see that we can easily fit a million records into a single
table....

However, if we put in 10 million names, we now got 1600 meg......and that is
now approaching the limit...

Of course..you can also use ms-access as a front end to sql server..and that
has a much larger capacity...

And, of course you can put each table in a seperate mdb..and link to that
(doing this in theroy would mean you can have a file about as large as you
want..but of couse we would be talking about seperate tables).
 
T

Todd Shillam

Peler,

It my memory is working correct tonight, depends on a couple factors. For
example, your file system. FAT16 has a 2GB file limit. Meanwhile, FAT32 has
a 4GB limit. NTFS--too big to worry about in nearly all cases.

Regardless, you really start to run into performance issues if your
Microsoft Access file exceed 2GB of storage. Although, I have seen larger
databases.

Otherwise, there really is no limit that I am aware of in terms of data you
would store in tables.

Best regards,

Todd
 
Top