SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Can't run query if ACCESS table exists      SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic View next topic Can't run query if ACCESS table exists Author Message shawn29316 Joined: 27 Dec 2007 Posts: 27 Country: United States Can't run query if ACCESS table exists I'm trying to run an SQL query which creates a table in an ACCESS database. The problem is that it runs fine if the table doesn't already exist but won't run if the table is already there. How can I just overwrite the old table? Thu Feb 21, 2008 1:40 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7949 Code: OnErrorResumeNext DatabaseExecute "DROP TABLE my_table", rows OnErrorStop Thu Feb 21, 2008 4:36 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.