•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 456,531 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,890 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 6598 | Replies: 1 | Solved
 |
•
•
Join Date: Jun 2007
Location: India
Posts: 41
Reputation: 
Rep Power: 2
Solved Threads: 2
Light Poster
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?
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?
•
•
Join Date: Jun 2007
Location: India
Posts: 41
Reputation:
Rep Power: 2
Solved Threads: 2
Light Poster
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
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- 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
