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.