There are all sorts of things that can cause a write conflict when using Access with tables linked to a back end database, but here’s one I hadn’t seen before: A date or datetime column with default values outside Access’ acceptable range. Specifically, the Zen Cart schema includes some fields with defaults of 0001-01-01! My client changed the defaults to 1901-01-01 and reports that Zen Cart continues to work ok, but your mileage may vary.
Applications | Data | Integration