Re: How to change username?

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.


"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message news:eL0YKhKVIHA.724@xxxxxxxxxxxxxxxxxxxxxxx
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.


--
Joan Wild
Microsoft Access MVP
"BruceM" <bamoob@xxxxxxxxxxxxxxxx> wrote in message news:%233JxNrHVIHA.4196@xxxxxxxxxxxxxxxxxxxxxxx
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.

"erick-flores" <erickjflores@xxxxxxxxx> wrote in message
news:7a7f73e2-37f5-4754-b405-f8b9d0e0c710@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Query to show last time someone logged in.
    ... >When my users log into my database a query automatically runs and creates a ... >new record in a table called tblUsageStats. ... >Username and the Current date & time ). ...
    (microsoft.public.access.queries)
  • Query to show last time someone logged in.
    ... When my users log into my database a query automatically runs and creates a ... new record in a table called tblUsageStats. ... Username and the Current date & time ). ...
    (microsoft.public.access.queries)
  • REPOST: bug in Forms Authentication
    ... i have a minor problem where some users log in with capital letters ... for their username, which looks bad when displayed on screen and also ... // find the Membership User ... // use the correct username case (from the aspnetdb database) ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How to change username?
    ... It has no connection to stored data. ... then have the users log in using the new names. ... The database control expenses for around 30+ ... Is there a way I can link the old username with ...
    (microsoft.public.access.security)
  • connection object in its own class file?
    ... I have a form that has username, password and database name fields. ... How do I handle the db connection? ... Thanks for reading this far and thanks for any suggestions or reading ...
    (microsoft.public.vsnet.general)
Loading