CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. January 19th, 2007, 02:22 AM #1
    chmanish's Avatar
    chmanish
    chmanish is offline Member
    Join Date
    Feb 2003
    Location
    India
    Posts
    232

    Extract table information from MS Access databse

    Hi Everyone,

    I have a MDB file which contains approximately 100 tables. I need to list all the tables along with information about fields (including name, type and size). Is there some tool for thsi purpose? or can I write some small application myself for this?

    I tried the Tools->Analyze->Documenter, but it just hung up my system and I could not do anything at all for a long time. So I ended the task.

    Can anybody tell me some tool/trick to do this work faster....

    please help....

    Manish
    Sarve Bhavantu Sukheenah,
    Sarve Santu Niramayah,
    Sarve Bhadrani Pashyantu,
    Ma Kashchit dukh bhag bhavet.
    Reply With Quote Reply With Quote
  2. January 21st, 2007, 03:02 PM #2
    klintan
    klintan is offline Member +
    Join Date
    Apr 2005
    Posts
    576

    Re: Extract table information from MS Access databse

    It is fairly easy to write an application to do this in VB 6.0 or .Net (like C# or VB.Net).

    A lot of tools can extract the information for you as well, like Visio, Enterprise Architect from Sparx Systems, and surely a lot of DB tools.
    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

Featured