#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Location
    UK
    Posts
    2
    Rep Power
    0

    'Metadata report from access'


    Hi everyone

    Is there are way to generate a list of all the objects created in my Access DB, in 'report forma report', or that I could transfer to, maybe, Word.

    Tried searching for 'metadata report' in helps screens and forums, though in truth not sure what it would be called.
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    650
    What is 'report forma report'?

    What version of Access?

    Access 2007 ribbon: DatabseTools>DatabaseDocumenter
    Will generate a very large report and runs very slow and outputs only to printer.

    Unhide system tables. Look at MSysObjects table. You can build Access report of these records or export to Word. But DO NOT modify the records.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm
  4. #3
  5. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    865
    Rep Power
    152
    Which version of Access are you using. The instructions for accessing the hidden system tables is slightly different depending on the version of Access you are using. But briefly you need to unhide the system tables - locate the MSysObjects table and note the fields you need to query. Create a query and use this query as your record source for a report. Make sure to hide these tables after you finish
    Alan Sidman
    Office 2010, 2007, 2002

    If I helped you, then click "give rep" button in the lower left corner.
  6. #4
  7. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    You might also have some luck with the msysNameMap table. it lists all of the database objects and a type ID. You can use the type id to sort them on a report. (basically the same thing as the MsysObjects table, but with less data in it to accidently mess up.)
  8. #5
  9. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Location
    UK
    Posts
    2
    Rep Power
    0
    Thanks guys, I've been able to build a query from MSysObjects to give me what I needed
  10. #6
  11. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2014
    Posts
    1
    Rep Power
    0
    In at least Microsoft Access 2007 and 2013, it has been my experience that some objects do not show up in the msysNameMap table so use MSysObjects instead. You might better try this code adding any other item you do not want to include in the Not IN items are use other criteria to find just reports, forms etc. Having strict naming conventions helps too, for example reports always begin with Rpt_, forms always begin with "frm" for example:
    select name from MSysObjects
    where mid(name,1,4) NOT IN ("~sq_","~TMP","MSys")
    order by name

Similar Threads

  1. Read mp3 metadata w/.NET ?
    By gcnason in forum .NET Development
    Replies: 2
    Last Post: February 4th, 2007, 05:23 AM
  2. Cos., Gov't Seek to Keep Lid on Metadata (AP)
    By RSS_News_User in forum Technology News
    Replies: 0
    Last Post: February 3rd, 2006, 06:03 PM
  3. Question about Metadata
    By u0107 in forum ASP Development
    Replies: 2
    Last Post: July 17th, 2005, 02:49 AM
  4. Extracting Metadata
    By DevAdmin in forum Development Articles
    Replies: 0
    Last Post: September 8th, 2004, 08:00 AM
  5. Access Metadata
    By fractalvibes in forum Microsoft Access Help
    Replies: 6
    Last Post: May 18th, 2004, 10:26 AM

IMN logo majestic logo threadwatch logo seochat tools logo