Drop Table if exists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles P. \(Pat\) Upshaw - 29 Jun 2004 18:10 GMT

I have a macro which drops a series of tables and relinks those same tables
from another database. I want to condition the drop on the existence of the
table.

How do I do this in the macro condition column?

Many thanks,
Pat Upshaw

Reply to this Message

Steve Schapel - 29 Jun 2004 19:16 GMT

Sorry, Pat, this is not possible. As far as I know, the only way to
handle this with macros is to run a Make-Table Query first. If the
table already exists, the make-table will overwrite it, but that doesn't
matter because you are going to trash it anyway. If it doesn't already
exist, it will now :-) Either way, you end up with a table of the
required name in existence.

Signature

Steve Schapel, Microsoft Access MVP

Charles P. (Pat) Upshaw wrote:

> I have a macro which drops a series of tables and relinks those same tables
> from another database. I want to condition the drop on the existence of the
[quoted text clipped - 4 lines]
> Many thanks,
> Pat Upshaw

Reply to this Message