finding out table size

I have had no trouble finding out that Access 2000 and 2003 have a 2GB
limit on table size. Now, how does one go about finding out how large a
table is. right click properties doesn't reveal this

Paris

"Paris" wrote in
news
I have had no trouble finding out that Access 2000 and 2003 have a 2GB
limit on table size. Now, how does one go about finding out how large a
table is. right click properties doesn't reveal this


It really doesn't matter how big a table is -- it just has to fit inside
the .mdb file. In any case, it's probably meaningless, since it's not
helpful to store a table without its indexes, relational constraints,
property sheets, and so on; which are presumably all scattered throughout
the file. Why do you care how big the table is?

Tim F

You could do some maths on the size of a record and multiply by number of
rows - but i seem to remember that there is an analysis tool -
tools-analyze table that should give you what you need.

You may need to install it from the CD if you have not already done so.
"Tim Ferguson" wrote in message
...
"Paris" wrote in
news
I have had no trouble finding out that Access 2000 and 2003 have a
2GB
limit on table size. Now, how does one go about finding out how large a
table is. right click properties doesn't reveal this


It really doesn't matter how big a table is -- it just has to fit inside
the .mdb file. In any case, it's probably meaningless, since it's not
helpful to store a table without its indexes, relational constraints,
property sheets, and so on; which are presumably all scattered throughout
the file. Why do you care how big the table is?

Tim F

Tim,
Thanks. I'll give it a whirl. In the mean time I've simulated the table
size over a year and it's still well below 2GB....no real issue anymore.

Paris
"BMW" wrote in message
...
You could do some maths on the size of a record and multiply by number of
rows - but i seem to remember that there is an analysis tool -
tools-analyze table that should give you what you need.

You may need to install it from the CD if you have not already done so.
"Tim Ferguson" wrote in message
...
"Paris" wrote in
news
I have had no trouble finding out that Access 2000 and 2003 have a
2GB
limit on table size. Now, how does one go about finding out how large
a
table is. right click properties doesn't reveal this


It really doesn't matter how big a table is -- it just has to fit inside
the .mdb file. In any case, it's probably meaningless, since it's not
helpful to store a table without its indexes, relational constraints,
property sheets, and so on; which are presumably all scattered
throughout
the file. Why do you care how big the table is?

Tim F