Check to see if a table exist.

[erwin001]

I'm looking for a way to determine if a table exist using VBA. If a specific table exists I want to delete it, then recreate a new table. If a specific table does not exist, then I will create the table. This is part of my dynamic search routine. I must create a table regardless, but I'm trying to trap for the condition when the table exists.

 

[RoyVidar]

What application? Word, Access, other???

For Access
1 - check out the Access fora (there's seven of them) forum search at the top of the page
2 - check out this thread705-933401

Roy-Vidar

 

[erwin001]

Access.

 

[erwin001]

Thanks!