how many records can be stored in an Access 2003 table?

G

Guest

There is no limit as it depends on the number of fields and th field types.
The help in access on limits and sizes states this

Table Size 2 gigabyte minus the space needed for the system objects
 
A

Albert D.Kallal

The size limit of access 2002 is 2 gigs.

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 / 120 = 32 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 64 million records in the file.
 

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

Similar Threads

How many records can an Access table hold 5
About Access limits 15
Call stored procedure in SSMS from Access 2016 doesn't work. 0
how many records(max) can be inserted in a table 3
Access 2003 Table Problem 2
find record on the Many side 3
Copies being made and Records being deleted by Access 3
Max Number of Records in a Table Challenge 5

Top