How to change username?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

erick-flores - 10 Jan 2008 16:31 GMT

Hello all

I have this big database and now I need to change ALL the users names.
Is there a way to rename a user name, or do I have to delete and add
it again (I DO NOT want to do this)?
I know how to change the password, but I have no idea about the user
name.

I do not want to delete then and add it again, because I will lost all
the data (I think)

Any ideas?

Thanks in advance

Reply to this Message

erick-flores - 10 Jan 2008 16:32 GMT

I am using MS Access 2003

Reply to this Message

Tom van Stiphout - 11 Jan 2008 02:02 GMT

Where are your user names stored? Since you're asking this in the
security newsgroup I'm thinking you're speaking of workgroup-level
security, right?
If right, how would deleting a user delete data?

-Tom.

>Hello all
>
[quoted text clipped - 10 lines]
>
>Thanks in advance

Reply to this Message

erick-flores - 11 Jan 2008 16:44 GMT

Yes, I do have workgroup-level security...sorry about that.

>If right, how would deleting a user delete data?

Well I am not sure thats why I said "I think"...

This is the scenario: The database control expenses for around 30+
users. Each user log in with Firstname Lastname. There are a LOT of
expenses already entered by these users. Users have their own database
on their laptops and the master database sits on a server, they sync
back n forth with it.

They want to log in using flastname. Example: Erick Flores (old user)
eflores (new user). Is there a way I can link the old username with
the new user name? I guess I understand I will not lost any data but I
want to keep the data from Erick Flores under eflores, all under the
same username..do you understand? In other words when they login to
the database, I want them to see their old data under their new
username.

Thanks for your help

Reply to this Message

BruceM - 11 Jan 2008 17:52 GMT

The user name is stored in the security mdw file. It has no connection to
stored data. Create the new user names, then have the users log in using
the new names. They will see the same data they saw with the old user name.

> Yes, I do have workgroup-level security...sorry about that.
>
[quoted text clipped - 16 lines]
>
> Thanks for your help

Reply to this Message

Joan Wild - 11 Jan 2008 23:18 GMT

Not exactly. I'm reading that erick is storing the username with the data that 'belongs' to that user.

So you'll need to delete all the users (no you can't change the existing usernames), recreate them, and then run a bunch of update queries to update the existing data to the new username. At least, I think that's the best way.

Signature

Joan Wild
Microsoft Access MVP

> The user name is stored in the security mdw file. It has no connection to
> stored data. Create the new user names, then have the users log in using
[quoted text clipped - 20 lines]
>>
>> Thanks for your help

Reply to this Message

BruceM - 14 Jan 2008 12:32 GMT

Oh, I see. I was reading it differently, but it's likely you're right. If
the new name is consistent with the example given it may be possible to use
a single query, with something like:
ShortName: Left([NameField],1) & _
Right([NameField],Len([NameField]-InStr([NameField]," "))

Even if it doesn't work in every case, it should do a lot of the work.

Not exactly. I'm reading that erick is storing the username with the data
that 'belongs' to that user.

So you'll need to delete all the users (no you can't change the existing
usernames), recreate them, and then run a bunch of update queries to update
the existing data to the new username. At least, I think that's the best
way.

Signature

Joan Wild
Microsoft Access MVP

> The user name is stored in the security mdw file. It has no connection to
> stored data. Create the new user names, then have the users log in using
[quoted text clipped - 21 lines]
>>
>> Thanks for your help

Reply to this Message

erick-flores - 14 Jan 2008 16:12 GMT

Thanks for the help. I was trying to avoid deleting all the users and
re-create them, but I guess thats the only way. Thanks again.

Reply to this Message

Joan Wild - 14 Jan 2008 20:16 GMT

It's not the only way, but it is the best in the long term.

You could add a field to your employee table with the new username, keeping the old one as well. Then you'd need to change all your queries/forms to look up the new username as needed.

Signature

Joan Wild
Microsoft Access MVP

> Thanks for the help. I was trying to avoid deleting all the users and
> re-create them, but I guess thats the only way. Thanks again.

Reply to this Message

erick-flores - 15 Jan 2008 17:43 GMT

OK. I am not 100% sure when we are going to implement the new user
name. But I will look into that option if we do so. Thanks

Reply to this Message