|
| 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
October 30th, 2006, 05:02 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
find out size of each table
Is there a way to show the size of the individual tables in an Access database?
It's well published that the maximum database size is 2Gb. Since I'm approaching this limit I'd like to know the size of each table within the MDB so I can figure out the best approach for an archiving strategy. Doug 
|
|
#2
October 30th, 2006, 05:05 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
find out size of each table
Answered in response to one of your posts in another newsgroup.
It is rarely necessary to post to more than one group ... but if you feel it is, posting separate questions to each 'group means you (and we) have to look at all the groups to find all the responses. If you post once, to all relevant groups, an answer in one shows up in all. Regards Jeff Boyce Microsoft Office/Access MVP "D Roswold" wrote in message ... Is there a way to show the size of the individual tables in an Access database? It's well published that the maximum database size is 2Gb. Since I'm approaching this limit I'd like to know the size of each table within the MDB so I can figure out the best approach for an archiving strategy. Doug
|
|
#3
October 31st, 2006, 10:23 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
find out size of each table
On Oct 30, 5:02 pm, D Roswold wrote: Is there a way to show the size of the individual tables in an Access database? ? CurrentProject.Connection.OpenSchema(adSchemaStati stics).GetString Jamie. --
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
