Access / SQL - Write Conflict Error

We've been using an Access Database to front a SQL Server database. It's handy in that we can leverage all the simple UI features that Access Provides, such as drop-down lists.

However, recently we had a problem when we couldn't update any rows and we were getting this mysterious "Write Conflict" error.

Turns out that Access UI tries to assign default values to columns, and for some data-types, this causes problems.

Here's the MS Knowledge base article: You may receive write conflict errors when you update records of a linked SQL Server table in Access 2000

Colbert Roasts President Bush

Saw the Repor(t) the other day where he called out some of the highlights from this speech, but it was out of context....

Here's the full speech...

awesome.

the mesquite-powered car.

Asynchronous client-side error logging

Finally got around to setting up a Bloglines account: handy tool.

While catching up on some of Scott Guthrie's posts, I was intrigued by Logging JavaScript Errors To ASP.NET

The code module is ASP.NET 2.0, and integrates with the Health Monitoring system.