Determine number of data pages used by each table

[Gila47ac]

Is there an easy way to determine the number of data pages (4 KB each) that a Microsoft Access table is stored in?

I have Access 2007, but the tables that I want to examine are in 2003 databases (.mdb files).

A programming solution is desired, but a manual solution is acceptable. I am not interested in commercial products.

 

[dhookom]

When you ask a technical question like this, you should probably tell us why you want the information. I have been creating Access applications since Access 1.0 and have never been interested in the number of data pages.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya Gila47ac . . .

Yeah! ... agree with [blue]dhookom[/blue]. whats the point?

Doesn't seem practical. I'd be much more interested in [blue]file size[/blue].

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Gila47ac]

I want the information to help me decide how to prioritize the offloading of data (which could be just to split the databases or to upgrade some tables to SQL Server) from the Access databases that I "inherited". The larger one is 1.6 GB in size. Each has many tables.

Yes, I know I can get a cruder estimation just by counting rows.

 

[jedraw]

See Orange999's post #7 at this site

http://www.utteraccess.com/forum/Determine-Table-Size-t1938952.html

It will give table size, not data pages.