|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 24th, 2007, 03:46 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
How to find Size of tables in Database
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? 
|
|
#2
April 24th, 2007, 06:08 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
How to find Size of tables in Database
You can find the number of rows by running a query:
Select count(*) as reccount from YourTable; but the actual size of a table isn't stored any place. You would need to approximate it by multiplying the record length by the record count. "Robin9876" wrote in message oups.com... 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?
|
|
#3
April 24th, 2007, 06:46 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
How to find Size of tables in Database
Why? As others have pointed out, Access tables exist only inside an Access
MDB file, so knowing the "size" means very little. Why do you care? Is this a homework-like question, prurient interest, or is there something you would want to do if you knew? Regards Jeff Boyce Microsoft Office/Access MVP "Robin9876" wrote in message oups.com... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
