Skip to main content
Participant
Oct 31, 2011 12:46 AM UTC
Answered

attempt to update a record in an Access database fails?

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

This topic is closed to new replies. Start a new post to keep the conversation going.
greenber2Correct answer
Participant
Oct 31, 2011 5:49 PM UTC

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

Viola! problem gone.

1 reply

greenber2AuthorCorrect answer
Participant
Oct 31, 2011 5:49 PM UTC

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

Viola! problem gone.

Translate