V
VUILLERMET Jacques
An Access ADP client works fine with a SQL Server 2000 database.
The client has a form to one table.
When I add a trigger (INSERT, UPDATE) on this table (the trigger modifies
the table, source code after signature) then Access is lost : error message
translated from French "Writing conflict - This record has been modified by
another user ... [Save record] [Copy to the Clipboard] [Cancel]".
The trigger works fine with another client, Query Analyser for example.
Is it possible to use Access (ADP) with triggers ?
Jacques.
***********************************************
CREATE TRIGGER trg_AvoidNullInNb ON [dbo].[MvtColis]
FOR INSERT, UPDATE
AS
UPDATE Mvtcolis
SET NbPal = 0
WHERE NbPal is null
UPDATE Mvtcolis
SET NbColis = 0
WHERE NbColis is null
UPDATE Mvtcolis
SET NbPlis = 0
WHERE NbPlis is null
UPDATE Mvtcolis
SET NbPiece = 0
WHERE NbPiece is null
/* Fin.*/
The client has a form to one table.
When I add a trigger (INSERT, UPDATE) on this table (the trigger modifies
the table, source code after signature) then Access is lost : error message
translated from French "Writing conflict - This record has been modified by
another user ... [Save record] [Copy to the Clipboard] [Cancel]".
The trigger works fine with another client, Query Analyser for example.
Is it possible to use Access (ADP) with triggers ?
Jacques.
***********************************************
CREATE TRIGGER trg_AvoidNullInNb ON [dbo].[MvtColis]
FOR INSERT, UPDATE
AS
UPDATE Mvtcolis
SET NbPal = 0
WHERE NbPal is null
UPDATE Mvtcolis
SET NbColis = 0
WHERE NbColis is null
UPDATE Mvtcolis
SET NbPlis = 0
WHERE NbPlis is null
UPDATE Mvtcolis
SET NbPiece = 0
WHERE NbPiece is null
/* Fin.*/