Results 1 to 2 of 2

Thread: how to obtain db structure info from an Access db in run-time?

  1. Aug 13th, 2005, 08:58 AM #1
    ultra2
    ultra2 is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    81

    how to obtain db structure info from an Access db in run-time?

    I use dataenvironment and adodb commands to communicate with and Access database from VB6.

    I need to get db structure information (such as tables count their names, their fields count and names) in run-time.

    so how can I write an sql statement to obtain that? or any other solution for this problem?

    plz help
    Reply With Quote Reply With Quote
  2. Aug 14th, 2005, 10:45 AM #2
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: how to obtain db structure info from an Access db in run-time?

    ultra2,

    Take a look in my signature for Multi Database Connection that project will give you all the help on doing just that.
    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