Member Avatar for kshrini

Hi All,

I'm developing an application using VB 6.0 & using MS Access 2000 as backend. How many records can I store in a table? Is there any such limit?

  • 1 Contributor
  • 1 Reply
  • 132 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by kshrini
Member Avatar for kshrini

Hi All,

I got the answer.
MS Access table can have size :
2 gigabyte minus the space needed for the system objects - MS Access 2003
2 gigabytes - MS Access XP
1 gigabytes - MS Access 2000

Accordingly we can calculate the maximum number of rows in our table depending on field size of each field.

Thanks & Regards,
Shrinivas

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.