Printing Database table configuration


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: Printing Database table configuration

  1. #1
    Join Date
    Mar 2005
    Location
    France
    Posts
    3

    Post Printing Database table configuration

    Hello every body,
    I'm new on this forum and need some help.
    I've created a database with MS-Access 2002 and I'd like now to print the configuration view of all my tables, the defined table links etc.
    So all the configuration stuf of my database but not the data content.
    Does someone know a nice tool for such a work (i.e like PrettyCode Print for VB) ?
    Thanks for your help

  2. #2
    Join Date
    Mar 2005
    Location
    Los Angeles, Calif. AKA: Gangsta Yoda™
    Posts
    455
    You mean that you want to printout the table relationships?
    If so go to Tools > Relationships... > and then File Print Relationship...
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer code questions via PMs.
    Microsoft MVP 2006-2009
    Office Development FAQ (VBA, VB6, VB.NET, C#)
    Software Engineer MCP (VB6 & .NET)
    Reps & Rating PostsVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6Outlook Global Address List

  3. #3
    Join Date
    Dec 2003
    Posts
    2,750
    How about using Tools...Analyze...Documenter in Microsoft Access?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  4. #4
    Join Date
    Mar 2005
    Location
    Los Angeles, Calif. AKA: Gangsta Yoda™
    Posts
    455
    Quote Originally Posted by pclement
    How about using Tools...Analyze...Documenter in Microsoft Access?
    Nice one . Could that be duplicated in code for easier access?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer code questions via PMs.
    Microsoft MVP 2006-2009
    Office Development FAQ (VBA, VB6, VB.NET, C#)
    Software Engineer MCP (VB6 & .NET)
    Reps & Rating PostsVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6Outlook Global Address List

  5. #5
    Join Date
    Dec 2003
    Posts
    2,750
    Quote Originally Posted by VBOfficeGuru
    Nice one . Could that be duplicated in code for easier access?
    Probably through DoCmd and/or RunCommand via automation, but I haven't tried it.

    If you're looking for a flexible code solution you would probably have to code your own using DAO, Access SQL DDL, ADOX or ADO schema methods.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  6. #6
    Join Date
    Mar 2005
    Location
    Los Angeles, Calif. AKA: Gangsta Yoda™
    Posts
    455
    Yes, I was looking for something easier then using ADOX.

    Thanks anyways. I will double check those for something.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer code questions via PMs.
    Microsoft MVP 2006-2009
    Office Development FAQ (VBA, VB6, VB.NET, C#)
    Software Engineer MCP (VB6 & .NET)
    Reps & Rating PostsVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6Outlook Global Address List

  7. #7
    Join Date
    Mar 2005
    Location
    France
    Posts
    3
    Thanks Paul,
    that was exactly what I was looking for (an it was 2 click away....)

    regards,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center