Table "size"?

  • Thread starter Thread starter Butch
  • Start date Start date
B

Butch

Hello,

According to Access 2000 Help, a table size must be up to 1 Mg.
How can I see the real (actual) size of a table?

P.-S: I looked in the "properties" of a table but the only things I can see
is the created date, the owner, etc.

Thank you.

Butch
 
As far as I know, you can't.

And, for what it's worth, I think you may have misread the Help. I don't
have Access 2000 installed, but I doubt it said "a table size must be up to
1 Mg". I suspect it said something along the lines that a table may be up to
2 gigabytes.
 
Hello Doug,

You're right! Access 2000 = 1 GIG for a table (that is what it is written
in the Help).

Thank you for the answer.

Butch
 
Hello,

According to Access 2000 Help, a table size must be up to 1 Mg.
How can I see the real (actual) size of a table?

P.-S: I looked in the "properties" of a table but the only things I can see
is the created date, the owner, etc.

Thank you.

Butch
Click to expand...

The Table has no independent existance. It is actually spread across
several undocumented portions of the .mdb file; there is system table
overhead, the size of the indexes on the table's fields, waste
space... There's very little you could do with the information about
the total size of "the table", even if there were a way to calculate
it!

There is no 1 MByte limit. A Table can be up to 1 GByte (1024 MByte),
and an entire .mdb file is limited to 2 GByte. Just keep your database
compacted; if you are approaching the 2 billion byte limit, or if
you've got upwards of ten million rows in your table, you need to
start considering upsizing to SQL/Server or another client/server
program, but below that Access should be fine.
 
My guess is that when they say that the size of a table can be "2 gigabyte
minus the space needed for the system objects" (Access 2003), what they REALLY
mean is that if you only have one table in the db then that's how big it can
be... so that's the limit on the size of a table.

BUT, if you have 2 tables in a db, then that same limit ("2 gigabyte minus the
space needed for the system objects") applies to the combined size of the two
tables.

Reading between the lines, it appears that there is no limit on the size of a
table, other than the limit imposed on the size of the whole database.

Rick
 
Back
Top