Everything I do is via VBA.
So for example to add a new record in my table tblActivity_Contact I do:
Dim dbContact As Database
Dim rsContact As Recordset
'open contact/hospitality table
Set dbContact = openDatabase(sourceDb, False, False, passwordDB)
Set rsContact =...