Disable Make Table Query Warnings in Access 2000

S

Samantha

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.
 
J

John Nurick

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.
 
S

Samantha

I thought so. I wanted to know if there's any easier method than to use 2
queries.
Thank you John for the confirmation.
 
Top