RDA - Dropping Pulled Errors_Table

hi,


I am using RDA with a desktop pc for a standalone security system.

After pulling a table and pushing it back out with more data i need to drop the table.. no problem i thought. I read that the errors table drops when you drop the related tracked table. However this doesn't seem to be the case, for me anyway.






Drop Tracked Table Code

Sub DropSwipes()
'Drop the Table
Try
Dim x As String = db.QueryScalar("SELECT Table_name FROM INFORMATION_SCHEMA.tables WHERE table_name = 'Swipes'")
If x = "Swipes" Then
db.Update("DROP TABLE Swipes")
End If
Catch ex As Exception
MsgBox("Drop failed")
MsgBox(ex.ToString)
Finally
End Try
End Sub

After running this code and then trying to pull a new tracked table i get a "Table Swipe_Errors Already exists". The tracked table itself has been dropped though.

any solutions or sugguestions would be excellent