Make table queriesd

  • Thread starter Thread starter Jonathan Crawford
  • Start date Start date
J

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
 
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?
Click to expand...

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!
 
Back
Top