A followup note to what I wound up doing last week when I had this error...
After fighting with it for three days, I finally went all the way back to the beginning and started over; about the only thing I kept was my original queries, content tables and recordsets -- but the contents of the pages themselves (and their associated interactions) were all deleted and replaced.
It took the better part of a day to do that, but after three days of trying everything else I could think of, it seemed the most cost-efficient solution...
Main Topics
Browse All Topics
by: ericpetePosted on 2001-02-06 at 14:53:18ID: 5818920
Been fighting with this one all day... *grin*...
It can mean a number of things, but usually, it's one of three things.
The most common is that you have an autonumber field, and you're trying to insert a number into it. When you do that, you essentially try and create a second record.
The second most common is that you're trying to enter data into the same record twice. For example, if you have a field on your page which puts data directly into the recordset, and there's already data in the field from a cookie somewhere, you'll get the error.
The third is that you're trying to enter a long string of data into a column of the database which has a restricted length (e.g. thirty characters into a field which has a length of twenty).
Given the description of the error, I'd bet on the second one...