On Mon, Dec 9, 2013 at 7:16 AM, Adrian Klaver <adrian.kla...@gmail.com>wrote:


> Is there a timestamp field in the view? This sounds like an issue Access
> has with timestamp precision, where if you supply a timestamp that is too
> precise it has problems. See here for more detail:
>

Updateable view can be a challenge due to MS-Access Optimistic Locking
checks.  First, for each row updated by Access, MS-Access checks that each
field is the same returning as what it issued - Any changes with throw a
roll-back.  Next if the count of record changes does not match the count
that that Access expects, it will roll-back the changes.


-- 
Regards,
Richard Broersma Jr.

Reply via email to