Creation of #temp tables in SQL via Access VBA pass through

[merebag]

I want to be able to create/drop/edit temp tables on my SQL server via access pass through vba processes. I have created select/update/delete sql queries using pass through



Dim qdf As DAO.QueryDef, rst As DAO.RecordsetSet qdf = CurrentDb.CreateQueryDef("")
qdf.Connect = "ODBC;DSN=XXXXXXX;Description=extday2;Trusted_Conn ection=Yes;DATABASE=XXXXXXX;AutoTranslate=No;Quote dId=No;AnsiNPW=No"
qdf.SQL = "SELECT * FROM tblAccountMaster"
qdf.ReturnsRecords = True
Set rst = qdf.OpenRecordset

This works... But when I try to do a CREATE TABLE command, I am not sure how to execute it. I know you wouldn't use an OpenRecordset for this. How would I do this via vba?

[ItsMe]

Assign the SQL to the SQL property and then

qdf.Execute dbFailOnError + dbSeeChanges

Edit:
actually, you might want to double check on the arguments. Not sure what might be required for creating a table "dbSeeChanges"

[merebag]

That works... I didnt need the dbSeeChanges, but the creation of temp tables worked.

Thanks again.