| Author |
 Topic Search  Topic Options
|
outtacash 
Newbie
Joined: 19 February 2003
Location: United States
Status: Offline
Points: 1
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Changing username ??
Posted: 19 February 2003 at 10:22pm |
Does anyone know if/how a member of a webwiz forum can change their username, but still keep their start date and post count,etc. ? I am admin for a forum and one of the members requested this and would rather not start from scratch. Thanks in advance.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 February 2003 at 6:59am |
The only way this is possible is to directly edit the database in Access or SQL server Enterprise manager, dependin which version you are running.
|
|
|
|
clavi
Newbie
Joined: 11 June 2003
Status: Offline
Points: 11
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 June 2003 at 8:03am |
Hi, in the Access db, there are 2 fields Username and User_code.
Do I need to modify both fields if I am changing the Username for
my users? Thanks in advance.
 -boRg- wrote:
The only way this is possible is to directly edit the database in Access or SQL server Enterprise manager, dependin which version you are running. |
|
|
kasl_33
Groupie
Joined: 15 June 2003
Location: United States
Status: Offline
Points: 86
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 June 2003 at 8:56am |
|
No, all you should have to do is edit the actual user name. You want the user ID number to stay as it is since it is most likely the primary key. Altering the Primary key will most likely not be allowed by Access, nor would it really be a smart idea.
|
|
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 June 2003 at 3:25pm |
|
The User_Code is not the primary key, the primary key is the AuthorID. The user_code is used is stored in the coookie for login purposesm, so it would need to be unique as well.
|
|
|
|
whittibo
Groupie
Joined: 24 May 2003
Location: United States
Status: Offline
Points: 180
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 July 2003 at 7:50pm |
Hello, I just loaded my Office Pro, I have never used Office or Access before. Can someone tell me how to open my database into Access, and modify it then reupload it again?!
I have a couple member names I would like to edit (possibly ~ if it's easy enough) but don't want to get myself in a mess of work here.
thanks so much!
|
|
zadax
Mod Builder Group
Joined: 19 January 2003
Location: Israel
Status: Offline
Points: 433
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2003 at 3:03am |
the best way to do it ts just o make new USER with the name u want ,,
and then modify the user ,,, add him is Group and posts ... [=
|
|
