R
Robin9876
How can you find out the size of tables in a database without having
to export each of the tables?
to export each of the tables?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Is this a homework question?
J
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
If this isn't homework, is this a sociology experiment?!
Regards
Jeff Boyce
Microsoft Office/Access MVP
J
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]
R
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.
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.
G
Guest
Have you done a compact and repair?
J
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]
R
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.
pictures or files.
It is an Access 2000 format database opened using Access 2003.
J
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]