I am currently trying to automate a process. The access db has three queries that need to be runned and then a report needs to be emailed out. Two of the queries are regular and one is a update query. Does anyone know how to run a update query automated through a macro or other means?

Also is there anyway to bypass or automate the prompt "The existing table 'name' will be deleted before ou run the query" that comes up when the query is runned?

Thanks for your time.

Update queries run the same as any other query. To shut off the warning, SetWarnings to false.

Suggest you do NOT use macros for anything other than maybe an autoexec.


see:

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=547442&Main=547442