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?

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,

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.