var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete Query on a Linked Table
In Access, I have a table ODBC-linked to DB2, say , SC1_T1 .
I have a delete query which looks like
delete * from SC1_T1 ;
When I run it, it does not show any errors ... But on DB2 the records are not deleted .... When I open the table in access in data sheet view, all records and fields are marked #Deleted ...
I'm on Access 2000 on W2K ...
My knowledge of access is too basic and so I do not know what's wrong ...
Thanks for any help ...
Re: Delete Query on a Linked Table
This is a known Microsoft bug.
Install msjet 4.0 sp6 available from Microsoft.
Alternatively, install WIN2K SP3 available from Microsoft