Make Table Query

  • Thread starter Thread starter Dave Ruhl
  • Start date Start date
D

Dave Ruhl

Hello, I want to run a Make Table query without being
prompted to replace the existing table. Is there a way
to do this without turning off 'Confirm Document
Deletions' in the Access Options ? Thanks...
 
If you are just running the query, then the answer is no.

If you are running the query from a macro or from VB then you can use
SetWarnings. Set it to false before the query, then true afterwards. In VB
it is DoCmd.SetWarnings.
 
Thanks! That's exactly what I needed!
-----Original Message-----
If you are just running the query, then the answer is no.

If you are running the query from a macro or from VB then you can use
SetWarnings. Set it to false before the query, then true afterwards. In VB
it is DoCmd.SetWarnings.

--
Kipp Woodard






.
Click to expand...
 
Back
Top