 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2005Calculating database size
I know 2 Gigs is the limit for Access. If I have a database with one table and only one field of type "Byte" (0-255 numbers), How many records can I add so that the database size is under 2 Gigs? Also can anyone explain how Access calculates a database size? Maxi Another scenario: If I have a database with one table and only one field of type "Text" with every record having a string 30 characters, How many records can I add so that the database size is under 2 Gigs? Maxi > I know 2 Gigs is the limit for Access. > [quoted text clipped - 5 lines] > > Maxi >I know 2 Gigs is the limit for Access. > >If I have a database with one table and only one field of type "Byte" (0-255 >numbers), How many records can I add so that the database size is under 2 >Gigs? A pointless exercise: however many records you add to this table, you can store the same information in a smaller table containing not more than 256 records with two fields, one Byte and one Long: just over 1 kb of data. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. I did not understand the answer. Actually, I want an answer for the second scenario: If I have a database with one table and only one field of type "Text" with every record having a string of 30 characters long, How many records can I add so that the database size is under 2 Gigs? > >I know 2 Gigs is the limit for Access. > > [quoted text clipped - 11 lines] > > Please respond in the newgroup and not by email. If you didn't understand my first answer, you don't understand the relational data model. As for your second example, depending on various settings and the barometric pressure, and assuming the table is not indexed, conceivably it could contain more than 30 million records. With an index, I'd guess - and it is a guess - maybe 10 to 20 million. But there's no formula to convert this into what would happen with different structures. more than 30 millionOn Tue, 8 Feb 2005 13:53:02 -0800, "mac_see" >I did not understand the answer. Actually, I want an answer for the second >scenario: [quoted text clipped - 19 lines] >> >> Please respond in the newgroup and not by email. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.