Results 1 to 6 of 6

Thread: iterate table in access database

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Posts
    2,580

    iterate table in access database

    I need and get the name of each table in database, how to?

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,393

    Re: iterate table in access database

    Step by step process:

    1. Open a web browser

    2. Enter https://www.google.com into the address bar

    3. When the page loads, enter "microsoft access get table names from database" into the Search box and press Enter.

    4. When the results appear, right-click on some of the links and select "Open in new Tab"

    5. Read the information on the links found

  3. #3
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    3,046

    Re: iterate table in access database

    Quote Originally Posted by jdc2000 View Post
    Step by step process:

    1. Open a web browser

    2. Enter https://www.google.com into the address bar

    3. When the page loads, enter "microsoft access get table names from database" into the Search box and press Enter.

    4. When the results appear, right-click on some of the links and select "Open in new Tab"

    5. Read the information on the links found
    excellent explanation for Luca, hope he will Post less ...how to?... now
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

  4. #4
    Addicted Member gilman's Avatar
    Join Date
    Jan 2017
    Location
    Bilbao
    Posts
    176

    Re: iterate table in access database

    Add a reference to Microsoft ADO Ext. for DDL and Security to your project and try:

    Code:
        Dim cat As ADOX.Catalog
        Dim T As ADOX.Table
        Set cat = New ADOX.Catalog
        With cat
            'put your string connection here
            .ActiveConnection = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Program Files (x86)\Microsoft Visual Studio\VB98\BIBLIO.MDB"
            For Each T In .Tables
                Debug.Print T.Name
            Next T
        End With

  5. #5
    PowerPoster
    Join Date
    Feb 2006
    Posts
    24,482

    Re: iterate table in access database

    You can also use Connection.OpenSchema() to query the tables list.

  6. #6
    Hyperactive Member
    Join Date
    Jan 2018
    Posts
    264

    Re: iterate table in access database

    Quote Originally Posted by jdc2000 View Post
    Step by step process:

    1. Open a web browser

    2. Enter https://www.google.com into the address bar

    3. When the page loads, enter "microsoft access get table names from database" into the Search box and press Enter.

    4. When the results appear, right-click on some of the links and select "Open in new Tab"

    5. Read the information on the links found
    This should be marked as the answer, but in general I would recommend preceding the search with "vb6" or even "vbforums", so enter "vb6 microsoft access get table names from database" and you will get results for VB higher in your search, many from this very site.
    I presume that Google is smart enough to look for English from the search criteria that you enter nowadays, but you might also try selecting English in Advanced Search?

Posting Permissions

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



Click Here to Expand Forum to Full Width