Datetime field overflow when inserting data from Access (1 Viewer)

[Pyro]

Why not move this logic to the server? Create an AFTER UPDATE trigger directly on tblNarrowFileObjects. Something like:

CREATE TRIGGER trg_UpdateLastUpdatedDate
ON tblNarrowFileObjects AFTER UPDATE AS
BEGIN
    UPDATE tblNarrowFileObjects
    SET LastUpdatedDate = SYSUTCDATETIME()
    FROM tblNarrowFileObjects t
    INNER JOIN inserted i ON t.ID = i.ID;
END;

 

[The_Doc_Man]

Thank you, @Pyro, for bringing up the UTC functions.

SYSUTCDATETIME() vs GETUTCDATE() in SQL Server: What’s the Difference?

SYSUTCDATETIME (Transact-SQL) - SQL Server

SYSUTCDATETIME returns a datetime2 value that contains the current date and time of the system.

learn.microsoft.com

 

[sonic8]

SYSUTCDATETIME() vs GETUTCDATE() in SQL Server: What’s the Difference?

The first returns an DateTime2(7) the other a DateTime data type.