Hi,

I have problems creating macro to delete a table in Access. It keeps prompting me "Action Failed". Can anyone advise what is wrong?

Thanks

can you save the macro as a vba module then post the code here?

Matt

Put the following into a module... seems to work...
If you need it in a macro you can call the function from your macro

================================================== =======
Public Function pfunDropTable(strTableName As String)
Dim strTemp As String

strTemp = "Drop table " & strTableName
DoCmd.RunSQL (strTemp)

End Function
================================================== =======