ODBC Error Code = 23000 (Integrity constraint violation)

[Idee]

I have a cold fusion application and I will trying to login, it resulted in an error:

ODBC Error Code = 23000 (Integrity constraint violation)

[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Then I just refreshed the page and it worked fine.

Could anyone give me the reason for this? Can the reason be that number of clients was more what actually access take at one time? If yes, any idea of this number?

Looking forward for a reply

Thanks

 

[cmmrfrds]

When you login is there an update query that runs against the database?

 

[Idee]

No, nothing is being updated, it just checks if user exists. I got the same error while generating a report.

Any clues?