Make table queriesd

[Jonathan Crawford]

Hi,

why do some make table queries automatically delete the table
if it already exists, whereas others stop with a message saying the
table already exists?

it seems to have somthing to do with the complexity of the query,
but really makes no ense
thank

Jonathanr

 

[John Vinson]

why do some make table queries automatically delete the table
if it already exists, whereas others stop with a message saying the
table already exists?

Could you have somewhere set SetWarnings False in a Macro, or done
DoCmd.SetWarnings False in VBA code? Doing so will suppress the
messages. I doubt it has anything to do with the query.

On another issue... why are you routinely running MakeTable queries?
They are VERY RARELY necessary! If you're making a table in order to
use it as the recordsource for a Form, or a Report, or an export -
consider using a Select query instead. The maketable just wastes time
and bloats your database, and doesn't give you anything you can't do
directly on a Query!