How to Check Pre-Existing Tables?

[cyspope]

Hi,

I am very new to Access and Visual Basics. I am trying to write a VBA code to do the following.

"If any table(s) exists in the current db, drop all the table(s)."

Basically, I am trying to drop all existing tables. Can anyone help me?

 

[Minty]

Are they linked tables or local?

 

[cyspope]

They are all local tables which reside in one Access file.

 

[spikepl]

So why would you want to drop ALL tables. That makes little sense. Normally temp tables would be wiped for content so they are empty and then filled again, instead of deletion.

Droping ALL tables means you have nothing, and your DB wil just explode in size after a few runs. In such a situation you just use a throw-away linked database - when done, work on a new pristine copy.