James suggested:
> Sounds like the problem was due to a system crash when the program was
open.
> We get this quite a bit.
>
> One (ugly) fix is to change the AutoInc field to an Integer field and save
> the table. Then go back and change it back to an AutoInc and save and pack
> the table. This resets the AutoInc field to the last number +1, and should
> allow posting to the table again.
>
Yes - almost!
Once you've changed it to Integer then it won't let you change it back to
AutoInc
BUT
If you delete the AutoInc field and then re-create it, it works
and fixes the Key Violation errors.
Thanks James and Craig
Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
