Re: How to find Size of tables in Database
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 Apr 2007 11:13:31 -0600
On 24 Apr 2007 08:02:45 -0700, Robin9876 <robin9876@xxxxxxxxxxx> wrote:
In an Access 2000 database how can you find the size of each table in
the database without having to export every table to a new file?
You can't, not easily anyway. Each table contains not only the data stored in
the fields, but system overhead; the indexes for the table take up space;
Access' lack of garbage collection means that a table may have a variable
amount of "wasted" space which will be recovered when you compact.
What GOOD does this information do you, anyway? A Table has no independent
existance outside the .MDB/.MDE file which contains it; you can't make it
bigger or smaller other than by doing the obvious - adding or deleting data
and then compacting the database; what use is it to know how many bytes it's
taking up within the Access database?
John W. Vinson [MVP]
.
- References:
- How to find Size of tables in Database
- From: Robin9876
- How to find Size of tables in Database
- Prev by Date: Re: storing objects with many features
- Next by Date: Re: How to show a negative number on the table
- Previous by thread: How to find Size of tables in Database
- Next by thread: How to find Size of tables in Database
- Index(es):
Relevant Pages
|
