DAO Rename User

[icecrew]

guyz,

I've written the following code but it doesn't work

Dim usrTemp as DAO.User

set usrTemp = wsMyWorkspace.Users("OldUsername")
usrTemp.Name = sNewUsername

upon reading VB's documentation I know that it failed because the 'Name' property is read-only. the documentation also states that it is read/write when 'unappended' however.

what's the correct way to rename a user? is it possible???

thanks

[PilgrimPete]

Couldn't you create a new user with your new name, copy all the old user's properties to the new user, append it to the collection and then delete the old user?

[icecrew]

hi PilgrimPete,

the thought did cross my mind ... i just thought there was an easier way ... guess i'll try it your way until i find an easier way - if it exists :-D

thanks 4 the suggestion,