Macro and Scheduled Task Prompt

Z

Zoe

I have created a macro that deletes 2 tables and replaces both tables using a
build table query. I have used the SetWarning action (No) before and after
each delete or build. I am using the macro in a sheduled task.

When the scheduled task statrts, everything appears fine, but then this
prompt appears:
Table 'TempMSysAccessObjects' already exists
If I click on the OK prompt, the process continues.

Any ideas where this prompt is coming from and how to get rid of it?

Thanks,
Zoe
 

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

Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
XP A2K TempMSysAccessObjects Runtime No Permission 1
Combining Multiple Schedules into One Schedule 0
Scheduled Macro hanging 4
Using Scheduled Tasks to run Macros problem 2
Remove prompt for replacing file 5
macro process running in task manager after the job is done 0
Scheduled task method of opening Excel questions. 1

Top