> > Perhaps the indices for the PKs are inactive. Can you try re-activating
> > it?
>
> I didn't know a PK could be made inactive. I dropped the PK and recreated

it

> and now things are normal.

Well, normally, this shouldn't be possible.

But it might have happened when restoring the database with indices
disabled. Is that something that could be possible in your case?

> Strange that all the PK's are doing the same thing - I wonder how this

could

> happen?
>
> Thanks for your help, much appreciated

No problem.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com