method to delete import error tables

[fasternu]

Is there a way to run a script to delete all import error tables? There has a been a couple mention of this topic in this forum but I haven't been able to get the code to work for me. Any help would be appreciated. thx

 

[DJN]

Try the following code.

Private Sub DeleteTable()
Dim tblTable As TableDef
For Each tblTable In CurrentDb.TableDefs
If tblTable.Name Like "Import*" Then
DoCmd.DeleteObject acTable, tblTable.Name
End If
Next
End Sub


David

 

[fasternu]

I tried that and I am getting an error msg that expression has a function name that MS Access can't find

I am using Access 2000