how many records can Microsoft Access hold?

G

Guest

Can someone please answer this question.

How many records can Access hold? MS state 2GB but I would like to know the
records.
 
A

Albert D. Kallal

You can put as many reocrds as will fit into 2gb.

So, teh number of reocrdds is going to depend on how large your reocrds
are....

So, if you take a average name in a mailing list, add a few extra
fields...your record size might be about 120 characters on average in size.

So, the number of records you can store is:

2 gig = 2,147,483,648 Bytes
1 Character = 1 Byte
120 Characters = 120 Bytes

2 gig / 120 = 17 million records

So, the limit is NOT the number of records..but "how many" records you can
fit into 2 gig.

Of course, if each customer name only takes up 60 characters...then you can
store 34 million records in the file.

so, the only limit is the 2GB size, and how many reocrds depends on the size
of each reocrd.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top