<div>
The following code will list all the object name from the msysobjects table all you will need to do is create an connection to the db.<br />
<br />
Public Sub listtablenames()<br />
&nbsp; &nbsp; Dim RS As New ADODB.Recordset<br />
&nbsp; &nbsp; RS.Open &quot;Select * from msysobjects&quot;, CN<br />
&nbsp; &nbsp; &nbsp; &nbsp; Do Until RS.EOF<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Debug.Print RS(&quot;Name&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS.MoveNext<br />
&nbsp; &nbsp; &nbsp; &nbsp; Loop<br />
&nbsp; &nbsp; RS.Close<br />
End Sub
</div>


The following code will list all the object name from the msysobjects table all you will need to do is create an connection to the db.

Public Sub listtablenames()
    Dim RS As New ADODB.Recordset
    RS.Open "Select * from msysobjects", CN
        Do Until RS.EOF
            Debug.Print RS("Name")
            RS.MoveNext
        Loop
    RS.Close
End Sub

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Ive been contracted to write a program to update the data structures and tables of an Access database when the client deploys an updated version of their software. &nbsp;This will run initially and upgrade the database with the latest fields and tables as required.<br />
<br />
However, im a little stumped as to how to read the table names from the MDB file. &nbsp;I cannot use constants for the table names in this case as the client will be using this program on several other projects as well.<br />
<br />
Is there a way to list the tables of an Access database using either ADO or DAO, or is there perhaps another method which I am overlooking?<br />
<br />
Thanks for your help.
</div>
</div>


Hello,

Ive been contracted to write a program to update the data structures and tables of an Access database when the client deploys an updated version of their software.  This will run initially and upgrade the database with the latest fields and tables as required.

However, im a little stumped as to how to read the table names from the MDB file.  I cannot use constants for the table names in this case as the client will be using this program on several other projects as well.

Is there a way to list the tables of an Access database using either ADO or DAO, or is there perhaps another method which I am overlooking?

Thanks for your help.

Listing Tables Using ADO or DAO

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.