Help for "Error repairing database: column Keyword is not unique"

[eddiechu]

Dear Sir,

I have encountered the message "Error repairing database: column Keyword is not unique" while I tried to compact & repair one of my .urd database file(Tools -> Compact and Repair Database -> Repair database).

Is there any way to repair this problem? I wish to keep the date & time info intact within the "Date Created" attribute.

I have tried "Export out then Import back" and "Copy down then Paste up" method from the corrupted file to a new file. Either one will keep the "Date Created" attribute intact.

Any suggestion is highly appreciated. Thanks