Hi,

About two years ago I had similar problem with one database
but it was Interbase6. The application was working fine
but in some situations reported database errors.

After short investigation I realised that the problem was a result
of the shut down (somebody switch-off the computer using the
power button).

I could easily do backup but couldn't restore. The solution that
worked in that case was just to delete one row do backup and
restore (the only problem was to find ONE record that was
duplicated!).

The PK was of type integer so it could be that problem has no
relation with the varchar type in your case.

Regards,
...michal

>
>