Wild character to find table in Access 2003 1

[lbigk]

Hello,
I used Access 97 for years, but now I have to switch to Access 2003. I am trying to delete any table that has the word "Error" in it's name.

I was trying a very simple command:
DoCmd.DeleteObject acTable, "*Errors*"

However, Access 2003 doesn't see "*" as any character. I also tested % and _ , according to Microsoft site it should have work, it doesn't.

Any assistance would be great.
Thank you.

 

[Remou]

You could try tabledefs.

Set db=CurrentDB
For Each tdf In db.TableDefs
  If Instr(tdf.Name,"Error")>0 Then
     DoCmd.DeleteObject acTable, tdf.Name
  End If
Next

Or there abouts.

 

[Remou]

I do not think there is a system table with Error in the name, but you may wish to watch out for system tables: the names all start MSys.

 

[lbigk]

Thank you, Remou, it worked perfectly.