DAO Execute query with parameters

[DylansStrings]

Hi
I'm using access 2003.
I want to execute a make table query saved in another access database. I use the DAO method below but the query has 2 input parameters and I want to pass these with the db.Execute method below. Is this possible?

Thanks

Dim db As DAO.Database
Set db = DBEngine.Workspaces(0).OpenDatabase("C:\Mydatabase.mdb")
db.Execute "MyQuery", dbFailOnError
Set db = Nothing

 

[DylansStrings]

Thanks figured it out with QueryDef

Dim db As DAO.Database
Dim MyQueryDef As DAO.QueryDef
Set db = DBEngine.Workspaces(0).OpenDatabase("C:\Mydatabase.mdb")
Set MyQueryDef = db.QueryDefs("MyQuery")

With MyQueryDef
.Parameters("[Year]") = 2012
.Parameters("[Month]") = 8
End With
MyQueryDef.Execute
Set db = Nothing