delete query - simple but i dnt get it?

[jimjamz]

This is so simple & i feel so stoopid...

I'm trying to delete recrods from tblWastage_AllProducts where there is matches from the temp table.

It gives me the error 'could not delete from specified tables'.
I just dont get it. ??


DELETE tblWastage_AllProducts.*
FROM tblWastage_AllProducts_TMP_delete INNER JOIN tblWastage_AllProducts ON tblWastage_AllProducts_TMP_delete.IndexWastage = tblWastage_AllProducts.IndexWastage;



I've never managed to do a delete from a Query & a table before thus i created two tables and will drop the temp table afterwards...

 

[waynewe]

try the following, sure it's what you want?


http://www.tek-tips.com/viewthread.cfm?qid=1247099&page=1

and

http://forums.devshed.com/postgresql-help-21/possible-to-use-inner-join-with-delete-84540.html

http://forums.databasejournal.com/archive/index.php/t-29848.html

http://www.thescripts.com/forum/thread189861.html

 

[jimjamz]

hi,

http://forums.databasejournal.com/ar...p/t-29848.html

is the closest that matches. And i've tried it originally as per code.
The other links are left unresolved....

I dont have any type of relationships on these table as of them is only a tempory table which i wish to drop later on.


Why is something so simple so hard? i dont understand why is.

 

[YamiMarik777]

See, I am trying to make a code that imports records into a existing table called tblInvoices from Excel spreadsheet. Then I want Access to delete records automatically from the tblOldInvoices table. I want this to run with a click of a button on my switchboard. This will be done by user every month. Any suggestions would be greatly appreciated. Thank you.