<div>
dim rs as dao.recordset<br />
<br />
set rs=currentdb.openrecordset<wbr />(&quot;select [Name] from msysobjects where type in(1,4)&quot;)
</div>


<div>
Thank you!<br />
How about specifying only linked tables?
</div>


<div>
linked tables have type 4 or 6
</div>


<div>
<div class="content wysiwyg-content">
I have an Access 2007 FE with SQL Server 2005 BE. I need to create a recordset with the names of all the tables.
</div>
</div>


I have an Access 2007 FE with SQL Server 2005 BE. I need to create a recordset with the names of all the tables.

create a recordset of table names

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.