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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Call stored procedure in SSMS from Access 2016 doesn't work. 0
How many records can an Access table hold 5
How to export table from outlook into ms access table? 0
About Access limits 15
Copies being made and Records being deleted by Access 3
Same record/Primary key in multiple tables 0
find record on the Many side 3
Stored date is not being recognised 1

Back
Top