Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Red face Unanswered: How can I get the infomation for the system tables,db in access?

    Hi, How can I get the tables names,index,field's names,system tables all information abaut db in microssoft access?


    Thanks,
    kestas

  2. #2
    Join Date
    Apr 2004
    Location
    UK
    Posts
    4
    You can either use the Access documenter function

    Tools, Analyze, Documenter which wil allow you to print out all the information you require or you could run queries over the hidden system tables (MSYSxxxxx) but you need the autority to view hidden/system tables to do this.

  3. #3
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: How can I get the infomation for the system tables,db in access?

    You can also create a tabledef and then loop through all the properties to either a particular table or all the tables.


    Originally posted by kestas
    Hi, How can I get the tables names,index,field's names,system tables all information abaut db in microssoft access?


    Thanks,
    kestas

Posting Permissions

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