J
jeff
Hi gurus
I have been successfully using passthrough queries to disable and enable
triggers on a MSSQL database table:-
EXECUTE sp_msforeachtable "ALTER TABLE tablename DISABLE TRIGGER ALL"
EXECUTE sp_msforeachtable "ALTER TABLE tablename ENABLE TRIGGER ALL"
through Linked tables in MSAccess.
The backend has been moved to an ORACLE server and I still need to do the
updates but cannot run the above passthrough queries. I also cannot update
the oracle table columns - i get the error
Write Conflict
The record has been changed etc.....
the error message is not correct.. i believe that the triggers are firing
and raising exceptions that Access doesnt interpret properly...
is there a way I can run a passthrough query to call an appropriate Oracle
Stored Procedure to do the same as MSSQL???
helllllpppppp!!!!
cheers
jeff
I have been successfully using passthrough queries to disable and enable
triggers on a MSSQL database table:-
EXECUTE sp_msforeachtable "ALTER TABLE tablename DISABLE TRIGGER ALL"
EXECUTE sp_msforeachtable "ALTER TABLE tablename ENABLE TRIGGER ALL"
through Linked tables in MSAccess.
The backend has been moved to an ORACLE server and I still need to do the
updates but cannot run the above passthrough queries. I also cannot update
the oracle table columns - i get the error
Write Conflict
The record has been changed etc.....
the error message is not correct.. i believe that the triggers are firing
and raising exceptions that Access doesnt interpret properly...
is there a way I can run a passthrough query to call an appropriate Oracle
Stored Procedure to do the same as MSSQL???
helllllpppppp!!!!
cheers
jeff