Calculating database size

mac_see

Active Member
Joined
Oct 15, 2002
Messages
419
I know 2 Gigs is the limit for Access.

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?

Also can anyone explain how Access calculates a database size?

Maxi
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
Hi Maxi
I presume this is related to your previous question regarding breaking up the csv field into it's 9 components. Intuitively I would think that you would almost double the size of the database by breaking up the csv value and storing it's separate components. But if you also doubled up on the csv value (like I proposed in the other thread) then you would triple the size of the database. It also depends on what else is in your database. You might want to run a compact and repair (under Tools -> Database Utilities) on the database before you run the queries. How big is the database now?
Andrew :)

[Late Edit] for data storage calculation purposes, 1 character = 1 byte but if your text field has a default size of 50 characters, then each record will have 50 bytes reserved x 200k records = 10m bytes = 9.5MB (1024 x 1024 bytes per MB) plus a bit for Access.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,187
Messages
5,594,753
Members
413,930
Latest member
Nela817

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top