How to see sizes of tables (or # of recs.) in detail view of Access 97?

  • Thread starter Thread starter Naum Litvin
  • Start date Start date
N

Naum Litvin

When I look at all tables in my DB (Access 97) in detail
view I see following properties for each table:
- Name
- Description
- Modified
- Created
- Type
How can I add "Size" to that view? I am looking not so
much for size in bytes, "Number of records" will be just
fine. It is often very helpful to see size of each table
in that list (something like "Field Chooser" as in
MS Outlook would be great). Any suggestions?
TIA
p.s. when responding, please CC my email
(e-mail address removed)
 
For LOCAL tables (not linked), this returns the record count:

codedb.tabledefs("MyTableName").RecordCount


This returns the description if it exists:

codedb.tabledefs("MyTableName").properties("description")


Two things you can do

1) You can write code to add the record count to the
description for each local table. Run an update whenever you
wish to see an updated value. Extend this to get the
value from linked tables by connecting to the linked
database.

2) Add a new menu item to the pop-up (right-click) menu
used for tables in the database window, that brings up a form
showing the current value (and any custom properties that
you want to add to the table)
 
Back
Top