Delete from Oracle tables using Access

[antomack]

I want to delete records for the run year/week from tables which have been migrated to Oracle from A97. What is the best way to do this? The current queries that worked while tables were in Access are now giving 'not an operable query' errors.

An example of the query involved:
DELETE Max_Archive.*
FROM Max_Archive
WHERE ((([Max_Archive].[Year_no])=[Year?]) AND (([Max_Archive].[Week_no])=[Week?]));

I have tried using Pass Through queries but no luck yet and also tried connecting through ADO but can't seem to get connection string correct.

Any help would be much appreciated.

 

[Turkbear]

Hi,
Why not connect to the Oracle database directly with SqlPlus or some other Oracle tool?
( The syntax shown is not correct for Oracle, so the pass-thru query probably will not work)

You need to be a user in Oracle that has sufficient rights to delete from that table.

If you cannot connect directly, try using a linked table in Access and be sure the link is read/write not read-only....