Number of data pages used by MS Access table

[Gila47ac]

Is there a simple way to determine the number of data pages that a Microsoft Access table is using?

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

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

 

[dhookom]

Can you provide some context to your question? What type of "pages" are you referring to?

Duane
Hook'D on Access
MS Access MVP

 

[Gila47ac]

Duane, I'm asking about data pages, as in the chunks (4 KB in size, starting with Jet 4.0) by which Access manages data in the .mdb file.

See, e.g.,

http://support.microsoft.com/kb/275561/en

 

[dhookom]

I guess I was wondering why the question. I have never found this to be important in any application I have created. Typically I use SQL Server as a back-end.

Duane
Hook'D on Access
MS Access MVP

 

[Gila47ac]

Why the question? Well, I have at least one .mdb file that is approaching the 2 GB limit, and would like to use the table sizes to help decide how to split the database. (Yes, I would like to move the data to SQL Server, but there are other priorities.)