I am trying to execute a Make Table Query in a VB program.

I have tried the following:

Set RS = DB.OpenRecordset("Select * from [Query Name")

This gives me error #3417 "An action query cannot be used as a row source"

I also tried the following:

Set MyWorkspace = Workspaces(0)
Set DB = OpenDatabase(stDatabasename, False, False)
MyWorkspace.BeginTrans
mDB.Execute "Select * from [Query Name]"
MyWorkspace.CommitTrans

This gives me error #3065 "Cannot execute a Select query"

Can anyone help me here please?