Thursday, January 14, 2010

To delete import error tables from database

To delete import error tables from database

Sub deleteimporterrors()

Dim tbldef As TableDef
For Each tbldef In CurrentDb.TableDefs
If tbldef.name Like "*_importerror*" Then
DoCmd.DeleteObject acTable, tbldef.name
End If
Next tbldef

End Sub
Regards:
KK Bhardwaj
info@bhardwajweb.com
kk43man@gmail.com
+91-9816464547
+91-9736399339
Bhardwaj Web Solutions
www.bhardwajweb.com
Himachal Pradesh

No comments:

Post a Comment