I managed to solve the problem. It was to do with setting "Allow Zero
Length" to Yes. Thanks for your help.
> 1. consider using SQL to do the update
> -dont let ADO do the work for you, do it yourself
> 2. even better a stored procedure
> 3. microsoft has a wonderful search engine
> do some digging, i bet you, you will find the problem super-fast :)
> At 06:20 PM 7/17/2001 +0000, you wrote:
> >I'm getting the following message:
> >Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >[Microsoft][ODBC Microsoft Access Driver]Error in row
> >/murray/listings.asp, line 50
> >I'm now getting it on all the files that used to work fine. The error
> >message is always at the objRec.Update section. All of this used to
> >and now it doesn't on a variety of different pages. Any suggestions
> >be greatly appreciated.
> Robert Chartier
> Author, AspFree.com