Access 2003 DeleteObject options

Home Forums Office Office XP / 2003 General Issues Access 2003 DeleteObject options

This topic contains 0 replies, has 1 voice, and was last updated by Avatar shadragon 8 years, 9 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Avatar
    shadragon
    Member
    #153003

    I inherited an Access DB that runs early each morning in a Scheduled task. (Why they set it up as a Scheduled task is beyond me as it sits there for hours waiting for me to come along hours later and click “OK” at every step, but I digress.)

    To keep it simple, there are three steps in the macro.

    DeleteObject “Table”
    Run a series of macros
    Save results in new “Table”

    Problem is, if “Table” does not exist (because of other badly written Access macros that run previously), it errors out at step 1 until I come along and create it, then re-run the macro to delete it.

    There has to be a better way. Is there any way in Access 2003 (We do not use VB) to either overwrite a table without deleting it, clear the contents of a table, or use ‘If then’ style logic to get over the fact that the table they are trying to delete has already been deleted.

    Thanks.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.