Update author field for all elements

[Maggie]

Hi
I want to update the author field of all elements in a model, so i thought I could do it in sql.
I have this code

Code: [Select]

UPDATE t_diagram
SET Author = "Bob Smith"
WHERE Author = "bob.smith"

But it has no effect.

I would be grateful if someone could show me the correct way of doing this

Thanks

Maggie

[Geert Bellekens]

Maggie,

That would only update the diagrams, not the elements.
To change the author for element you have to update t_object.

Code: [Select]

UPDATE t_object
SET Author = 'Bob Smith'
WHERE Author = 'bob.smith'
And I think you need to replace the double quotes with single quotes for it to work (although I'm not 100% sure about he Access syntax)

Geert

[Maggie]

Thanks!!