Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    London, England
    Thanked 0 Times in 0 Posts

    Make Table Query Problem (2000)

    Just a quick question. I am running a make table query from code and I thought that a make table queriy would overwrite an existing table with the same name as the table being created. However, I have one that comes back with a runtime error 3010, 'table already exists'. Is this a setting? If it is I cannot find anything in the Options menu that might help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Make Table Query Problem (2000)

    This is normal behavior; according to the online help, a trappable error occurs if the table already exists.

    You can delete the table in the error handling section, then resume the code. Post back if this is abacadabra to you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts