Access 2010 Macro Help

[RayMilhon]

I have an MS Access 2010 Database that is populated nightly from SQL Server using Windows Scheduler and the autoexec Macro. The macro should run populate 2 tables and shut Access down. The problem is that if SQL Server is unavailable for any reason the Macro errors and displays the error message and waits for a user to click on the halt button. I want it to automatically halt and exit the database without user intervention. Is this possible?

[Robeen]

Do you already have the SetWarnings action in your Macro set to 'No'?

[RayMilhon]

Yep. The problem is that the SQL Server DB is a Reporting DB copied from a Production DB on a nightly basis. Occassionaly the copy fails and the Reporting DB is unavailable. Since the Access DB is automated to run prior to anyone coming in The Link to SQL Server may be down when the macro runs. The macro steps are in order:

1. Set Warnings off
2. Copy tbl_Auths to tbl_auths_backup
3. Copy tbl_Claims to tbl_Claims_backup
4. Run Make table Query to create tbl_Auths
5. Run Make table Query to create tbl_claims
6. Set Warnings on
7. Close Database

As soon as step 4 errors There is a halt Macro screen that comes up caused by the error. What I want is if the error occurs copy the tbl_auth_backup back to tbl_auths and just to be safe do the same for tbl_claims and then exit the database.

[Robeen]

Ray,
I'm not sure I can help with this. Sorry.
It might be a good idea to re-post.