DAO Rename User

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

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?

hi PilgrimPete, :D

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,