attempt to update a record in an Access database fails?

[greenber2]

I get the following error message (s) when I try to do the actual update:

"

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

/edit.asp, line 45"

Where line 45 is the actual update command.

I am using Dreamweaver CS 5.

Any help you can give me is vastly appreciated!

Thanks.

Ross

[greenber2 · Accepted solution]

I ended up fixing it: I turned off  Unicode and reduced the varchar from 255 (default) to 200.

Viola! problem gone.