Recent content by donames

Interesting. The code or sql statement is fine. Resolution I figured was deleting the linked table and relink table with good index. The reason it failed was due to undefined or lost index. Thank you for all your help!

Not sure I understand you. The sql statement is in query executed in vba code.

The delete query is in vba code. We are trying to delete the row from linked table AND flag at access table that matches the month date at linked table. The flag is set true based on user's month selection. When the deletion is made, the flag is to be set false or deleted.

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.*...

Don Ames here! Been doing the big MS Access maintenance at work for few years. Never did the access code from scratch. I studied the apps at Learning Tree courses covering basic, advanced, vba, etc. Been programmer since 1976. Now I am into SQL world.