Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

Access 2003 DeleteObject options

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

Viewing 1 post (of 1 total)
  • Author
    Posts

  • 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.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: