How to find Size of tables in Database

[Robin9876]

How can you find out the size of tables in a database without having
to export each of the tables?

 

[Guest]

Is this a homework question?

 

[Jeff Boyce]

Didn't you post this same question yesterday?

If this isn't homework, is this a sociology experiment?!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

How can you find out the size of tables in a database without having
to export each of the tables?

Perhaps the three answers that you got yesterday aren't to your liking... but
they are correct. Asking the question again won't get you much more.

John W. Vinson [MVP]

 

[Robin9876]

Sorry about the multiple posting but the original post was not
appearing in the newsgroups from my pc even a few days after my
original post, therefore I posted it again.

I have a 2Gb access database with a number of tables (50+) and I
wondered if their was any easy way of identifying the largest table in
database to possibly move to another database.

 

[Guest]

Have you done a compact and repair?

 

[John W. Vinson]

I have a 2Gb access database with a number of tables (50+) and I
wondered if their was any easy way of identifying the largest table in
database to possibly move to another database.

What version of Access? and... do you have any Pictures stored in any of these
tables? Versions of Access prior to the latest (2007) handle graphic images
VERY inefficiently, and even a few pictures can bloat a database to enormous
size.


John W. Vinson [MVP]

 

[Robin9876]

I have done a compact and repair and the tables do not contain any
pictures or files.

It is an Access 2000 format database opened using Access 2003.

 

[John W. Vinson]

I have done a compact and repair and the tables do not contain any
pictures or files.

It is an Access 2000 format database opened using Access 2003.

If it's *over* 2GByte it may be corrupt and may not let you compact. Can you
create a new database and Import tables? How many rows in the largest table?
You may well be exceeding what Access can handle: have you considered using
Access as a frontend to a client/server database such as SQL/Server?

John W. Vinson [MVP]