Programatically deleting tables

[greatwhite]

I am deleting some temps table and if they don't exist I get an error.

So I wanted to test first if the table exists.
Something like this


Set Db = CurrentDb
If Exists (Db.TableDefs("tblShip_Temp")) Then -----------------------------------Doesn't work
Db.TableDefs.Delete ("tblShip_Temp")


End If

[JoeM]

Take a look here: http://www.iaccessworld.com/function-istableexists/

[greatwhite]

Thanks just what I was looking for.

Take a look here: http://www.iaccessworld.com/function-istableexists/

[JoeM]

You are welcome.