delete table

[tinoco]

Hi!!
How can i delete an oracle table from access 2003 using vba code?
i'm using ODBC to link the two databases.
thanks

 

[PHV]

You may excute a passthru DDL query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tinoco]

but how can i link this king of query with the oracle database?
thanks

 

[lynchg]

Are you sure you want to delete the actual Oracle table, or do you want to just remove it from your table list in Access?

 

[tinoco]

but ao can i link the query with the oracle database?

 

[PHV]

The connection string is a property of a passthru query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tinoco]

yes i want to delete it because i'm exporting data from access to oracle through odbc. my problem is that i can just export data once for de same table and i want to fill it up everytime i perform my access application.
The append query doesn't recognise ODBC databases so i can't use it!!

 

[lynchg]

Do you just want to delete the records out of the Oracle table, or delete the table entirely?

 

[tinoco]

i want the oracle table entirely!
is it possible?
thanks

 

[PHV]

Again, a passthrough query:
DROP TABLE oracle table name

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

The append query doesn't recognise ODBC databases
Really ? Even the linked tables ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tinoco]

its solved.
thanks a lot for the help