I have an application that provides the ability to export all of the Queries, Forms, Reports, and Macros for backup or sharing using the following code:

(One for each Collection Type)

Public Sub QueryExp()

Dim dbs As Object
Dim obj As AccessObject
Dim strName As String

Set dbs = Application.CurrentData

For Each obj In dbs.AllQueries
    strName = obj.Name
    
    DoCmd.TransferDatabase _
        TransferType:=acExport, _
        DatabaseType:="Microsoft Access", _
        DatabaseName:=CurrentProject.Path & "\MyTools\MyTools.MDB", _
        ObjectType:=acQuery, _
        Source:=strName, _
        Destination:=strName, _
        StructureOnly:=False

Next obj

End Sub

Using the same tool, I know how to import an individual item. Is it possible to scan through the collection of a second Access MDB from within the first MDB?