Calculating database size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

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?
Click to expand...

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.
 
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?
 
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"
 
Back
Top