Results 1 to 5 of 5
  1. #1
    lenlab is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    24

    Count of Tables, Queries etc.

    Is there some way to get a count of all the tables, queries, macros, forms etc. that are in the database by type?

    I know I can simply eyeball and count them but was wondering if this info is available or there is a utility that will do this?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I think Jeff's CSD Tool will do that: http://www.accessmvp.com/jconrad/acc.../csdtools.html

  3. #3
    lenlab is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    24
    Solved. Although I am using Office 2010 and this utility does not work with it, I have access (no pun intended) to an older version of office and used it. It is a great utility with lots of database info.

    Thanks!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome and now I also know it does not work with ac2010.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I actually read the site this time and it says right at the top, Not ready for ac2007 yet. D'uh

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-20-2013, 02:14 PM
  2. Count date entries from seperate tables/queries
    By krutoigoga in forum Queries
    Replies: 3
    Last Post: 06-30-2011, 12:48 PM
  3. Count tables for a new guy.
    By th1nk1nk in forum Database Design
    Replies: 4
    Last Post: 11-19-2010, 05:33 PM
  4. using COUNT for multiple tables
    By kwalt in forum Programming
    Replies: 1
    Last Post: 02-17-2009, 04:05 PM
  5. using COUNT for multiple tables
    By kwalt in forum Queries
    Replies: 0
    Last Post: 02-17-2009, 03:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums