In my understanding, you can set the RecordSource of any ADO recordset to an SQL statement.
so something lik
Dim Db As Database, Rs As Recordset
Set Db = Workspaces(0).OpenDatabase("Music.mdb")
Set Rs = Db.OpenRecordset("SELECT Record.Rnr, Sname, SLength FROM Record, Song...