var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete Query
I am trying to run a delete query.
I have 2 tables.
Table A and Table B.
Table B holds all the records that I want to delete from Table A.
In the query I create a link between the two tables. When I preview the query it displays all the records I want to delete.
When I run the query in delete mode – it says “Could not delete from Specified table”
Can anyone helpmeplease!
You can't delete because your criteria for the deletion is a join. The join effectively locks your records preventing deletion.
You can, however, get round this with EXISTS
Personnally I tend to plump for Exists
ur codings are working excelent.