Hi,
I am using MS access as a front end, and have a query thats meant to delete the MySql table contents. Sometimes it works sometimes it doesnt. when it doesnt it gives me ODBC 3146 runtime error. Any ideas on what could be wrong?? Is it a setting within the ODBC client setup or some sort of timeout??
Heres the query:
Function Delete_Table_Mysql_Lar041()
Dim DelLar041 As String
DelLar041 = "DELETE mysql_lar041.*, * FROM Mysql_lar041;"
DoCmd.SetWarnings warningsoff
DoCmd.RunSQL DelLar041
DoCmd.SetWarnings warningson
End Function
I am using MS access as a front end, and have a query thats meant to delete the MySql table contents. Sometimes it works sometimes it doesnt. when it doesnt it gives me ODBC 3146 runtime error. Any ideas on what could be wrong?? Is it a setting within the ODBC client setup or some sort of timeout??
Heres the query:
Function Delete_Table_Mysql_Lar041()
Dim DelLar041 As String
DelLar041 = "DELETE mysql_lar041.*, * FROM Mysql_lar041;"
DoCmd.SetWarnings warningsoff
DoCmd.RunSQL DelLar041
DoCmd.SetWarnings warningson
End Function