April15Hater
Accountant
- Local time
- Today, 13:33
- Joined
- Sep 12, 2008
- Messages
- 349
Sometimes 'tblPeoplesoft' will be missing, sometimes 'import' will be missing.
Either way, I just said screw the errors, just run it, if it's there it'll drop it. Something tells me this shortcut will bite me later (especially since my weak point is error handling). Any reason not to do this?
Code:
DoCmd.SetWarnings False
On Error Resume Next
CurrentDb.Execute "DROP TABLE tblPeoplesoft"
CurrentDb.Execute "DROP TABLE Import"
On Error GoTo 0
DoCmd.SetWarnings False
Either way, I just said screw the errors, just run it, if it's there it'll drop it. Something tells me this shortcut will bite me later (especially since my weak point is error handling). Any reason not to do this?