| | |
Maximum record limit
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Jun 2007
Posts: 44
Reputation:
Solved Threads: 3
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
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
![]() |
Similar Threads
- online examination (Java)
- VB 6.0. Creating a file for random access (Visual Basic 4 / 5 / 6)
- What do you pay for your :: Internet Connection? (Geeks' Lounge)
- maximum memory limit? (C)
- Sharing DSL BETWEEN 2 BUILDINGS (Networking Hardware Configuration)
- another newbie with alot of redhat and apache server Q'S (Linux Servers and Apache)
- hav a problem with this query (MySQL)
- cd burner speed (Storage)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: How can I connect MS Access to SYBASE ASE db without repeatedly enter a user & passwd
- Next Thread: Back up for Outlook 2003 Contacts
| Thread Tools | Search this Thread |





