Delete table, if present statement 1

[vamoose]

I am using Access 2000. Currently I am using this VBA code: DoCmd.DeleteObject acTable, "SAP_Import" to delete this table. I would like to know if this table is actually present before issuing the above command because I get an error if the table is not there to delete.

Thank you for any assistance.

 

[Remou]

You can look up a system table.

[tt]If IsNull(DLookUp("Name","MSysObjects","Name='SAP_Import' And Type=1")) Then
'Does not exist[/tt]

Type 1 is a local table.

 

[vamoose]

EXCELLENT, THANK YOU.