I have created an Automation Designer app that will create two tables in an Access database. Select #1 is supposed to create table #1. Select #2 is supposed to create table #2. After the app runs I get two tables, but they are both the results of select #2. This happens regardless of whether I say "Overwite" or "append if columns match".
WORKAROUND 1:
1. Close/realunch Toad after creating the App
WORKAROUND 2:
Create the app actions directly in Automation Designer i.e. do not take snapshot of export dataset i
In Automation Designer:
1. Create new App | rename App
2. On the right hand side click the Import/Export tab
Double-click export dataset button (4th icon from left)
Click on the dataset tab and paste your query
Go back to Options tab and complete as required
Repeat for second action
STATUS
Waiting for fix in a future release of Toad for Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center