Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Error 7874

Discussion in 'Information Technology' started by CyberDwarf, Jul 28, 2006.

Tags:
  1. CyberDwarf

    CyberDwarf
    Expand Collapse
    Guest

    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.

    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
     
  2. Loading...


Share This Page