[AccessD] Open an Access DB from within the main DB

[Stuart McLachlan]

On 10 Oct 2022 at 21:16, Arthur Fuller wrote:

> I think I've asked this before, and received an answer, but can't find
> it. 

You mean this answer to essentially the same question less than 2 months ago?

On 24 Aug 2022 at 7:52, Stuart McLachlan wrote:

> Yes.
> This gets the tables. Over to you to get the fields from them and
> populate comboboxes.
> 
> Function ListTables(myDB As String) As Long
> Dim db1 As dao.Database
> Dim tdf As TableDefs
> Dim td As TableDef
> Set db1 = DBEngine.OpenDatabase(myDB)
> Set tdf = db1.TableDefs
> For Each td In tdf
>     Debug.Print td.Name
> Next
> End Function
> 
>