finding out table size

[Paris]

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

 

[Tim Ferguson]

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

 

[BMW]

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.

 

[Paris]

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