Error 7874

Hi y'all

I have hit a problem within Access which gives the error message:-
" Error 7874 - Access cannot find object 'Select column1 as 1, column0 as 2....' "

This follows a save (in VB) for a new record to the backend SQL Server table.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14050-error-7874-a.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14050

There is an insert trigger which inserts an audit trail record to a different table, but this trigger functions perfectly (rows all inserted correctly).

In addition, the Update & Delete triggers (with the identical functionality) work perfectly & generate no errors within the VB code..... :-o

I've seen this error in all sorts of contexts on forums, but nothing as yet to help.

TIA

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!