The MS Access Error Code '3086' issue.
Platform Windows 7 Professional (applies to Windows XP as well)
MS Access version 2010 (applies to version 2007 as well)
Error Code Returned: 3086 on delete statement only
This sometimes works fine. It sometimes fails.
DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3]
FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1
WHERE ((tblItem1.item2 = True)
and (LINKED_TABLE.item3 = Forms!frmItem3!DateField));
Only solution I find is moving INNER JOIN clause to new line (HEX (0D 0A)) as follows:
DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3]
FROM LINKED_TABLE
INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1
WHERE ((tblItem1.item2 = True)
and (LINKED_TABLE.item3 = Forms!frmItem3!DateField));
Then I SAVED the query and I ran the query and it works fine.
After I close the MS Access apps, when I re-launched the access, the syntax shows the old format (new line shifted back to old line as HEX(0D 0A) disappeared) as follows:
DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3]
FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1
WHERE ((tblItem1.item2 = True)
and (LINKED_TABLE.item3 = Forms!frmItem3!DateField));
Why does the internal SQL syntax change at each time the MS Access is launched?
Platform Windows 7 Professional (applies to Windows XP as well)
MS Access version 2010 (applies to version 2007 as well)
Error Code Returned: 3086 on delete statement only
This sometimes works fine. It sometimes fails.
DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3]
FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1
WHERE ((tblItem1.item2 = True)
and (LINKED_TABLE.item3 = Forms!frmItem3!DateField));
Only solution I find is moving INNER JOIN clause to new line (HEX (0D 0A)) as follows:
DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3]
FROM LINKED_TABLE
INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1
WHERE ((tblItem1.item2 = True)
and (LINKED_TABLE.item3 = Forms!frmItem3!DateField));
Then I SAVED the query and I ran the query and it works fine.
After I close the MS Access apps, when I re-launched the access, the syntax shows the old format (new line shifted back to old line as HEX(0D 0A) disappeared) as follows:
DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3]
FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1
WHERE ((tblItem1.item2 = True)
and (LINKED_TABLE.item3 = Forms!frmItem3!DateField));
Why does the internal SQL syntax change at each time the MS Access is launched?