Results 1 to 3 of 3

Thread: listing of msAccess database objects

  1. Sep 25th, 2003, 07:40 AM #1
    danyrib
    danyrib is offline

    Thread Starter
    New Member
    Join Date
    Sep 2003
    Location
    France
    Posts
    1

    listing of msAccess database objects

    I'm looking for a solution to get the names of the forms and reports included in an msAccess database
    I know how to do to get names of tables and queries with ado or adox but I can't see reports or forms with this method.
    Any idea ... ?
    Thanks.
    Reply With Quote Reply With Quote
  2. Sep 25th, 2003, 07:49 AM #2
    vb_dba
    vb_dba is offline
    Fanatic Member vb_dba's Avatar
    Join Date
    Jun 2001
    Location
    Somewhere aloft between the real world and insanity
    Posts
    1,016
    There is a system table in Access called MSysObjects that lists the objects in the DB. You can run a query on this table returning the name and type fields. I'm not that familiar with the table, but you should be able to look at the name and the type number, then run your query based off the type number to return the forms, reports, etc. that you desire.
    Chris

    Master Of My Domain
    Got A Question? Look Here First
    Reply With Quote Reply With Quote
  3. Sep 25th, 2003, 08:47 AM #3
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    If you had searched the forum first...you would have found this thread.

    Get a list of all objects in Access Database.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width