Disable Make Table Query Warnings in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
How can I disable the warnings in executing a make table query? I have a
command button that executes the make table query with the following code:

CurrentDb.Execute "qryRODetailTempMake", dbFailOnError

But, I'm getting the Run-Time error '3010': Table 'RODetailTemp2' arleady
exists.

I basically want the temp table to be refreshed with the new data everytime
the button is clicked. Anyone has any ideas on this? Thanks in advance.
 
Hi Samantha,

If the table already exists, you don't want to use a make-table query.
Instead, use two queries: one to delete the old data, e.g.

DELETE FROM R0DetailTemp2

and another to append the new data. Then use two calls to
CurrentDB.Execute to execute the two queries.
 
I thought so. I wanted to know if there's any easier method than to use 2
queries.
Thank you John for the confirmation.
 

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

Warning message in Access 2003 4
One form, two tables UPDATE help? 4
Add new record to related table and show data on form 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Executing make-table queries with VBA 7
Run-time error 3061 excel to access 1
Table in wrong MDB 3
Performing a make table query from a form button 16

Back
Top