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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make table query: [Enter 1] AS Test 1
Make Table Query Popups 9
Confirm Table Deletion Box in Make Table Query 2
Append Query Issue 0
Turning off action query confirmation messages 1
Make Table query, but remove character from field 5
Access 2010 append query to SQL is very slow 0
Make-table query with around 2 ml records taking too long 0

Back
Top