Maximum record limit

Expand Post »

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?

Similar Threads

online examination in Java
VB 6.0. Creating a file for random access in Visual Basic 4 / 5 / 6
What do you pay for your :: Internet Connection? in Geeks' Lounge
maximum memory limit? in C

kshrini

Reputation Points: 10

Solved Threads: 3

Light Poster

Offline

45 posts
since Jun 2007

Permalink

Oct 5th, 2007

Re: Maximum record 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,
Shrinivas

kshrini

Reputation Points: 10

Solved Threads: 3

Light Poster

Offline

45 posts
since Jun 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: How can I connect MS Access to SYBASE ASE db without repeatedly enter a user & passwd

Next Thread in MS Access and FileMaker Pro Forum Timeline: Back up for Outlook 2003 Contacts

DaniWeb Message

Cancel Changes

User Name
Password