Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Unanswered: Storing all database object names in table

    How do I store all of the names of my database objects (tables, queries, forms, macros, modules) in a table? I know how to run through all the tables and queries, but the forms need to be open for the database to see them. Is there a way to find everything? I know the documenter can, but is there a way for me to extract that data?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by knowlja1
    How do I store all of the names of my database objects (tables, queries, forms, macros, modules) in a table? I know how to run through all the tables and queries, but the forms need to be open for the database to see them. Is there a way to find everything? I know the documenter can, but is there a way for me to extract that data?
    It's already there! Have a look at the Msysobjects table. If you can't see it, check tools-> options and select the "view system objects" (or similar) tab.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Mar 2005
    Posts
    2

    Talking

    Thank you so much! I knew it was stored somewhere because I could see the list under file, database properties, contents; but I could not see it. You have saved me! Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •