| Author |
 Topic  |
|
|
Lucky
Junior Member
USA
127 Posts |
 Posted - 05 January 2003 : 16:52:03
|
Background: We'd like to add the member's ID number in the author box.
Question: Is it possible to change the member_id of a member? We'd like to make the first 'real' member (member_id 3) become member_id 1.
When we open the database in MS Access and try to change the member_id, it will not allow it.
Thanks! |
~Lucky |
Edited by - ruirib on 05 January 2003 17:57:53 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 January 2003 : 16:59:48
|
| You can not change member_id. Switch the usernames and passwords. But that will create problems with messages posted. |
Edited by - GauravBhabu on 05 January 2003 17:00:55 |
 |
|
|
Lucky
Junior Member
USA
127 Posts |
Posted - 05 January 2003 : 17:09:04
|
| Is there any way of switching all messages posted for a user or any other way of changing the member_id? |
~Lucky |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 January 2003 : 17:13:35
|
How many messages you have for each user?
To keep the mesages in synch, you will also need to switch the Member_Id's in Forum_Reply, Forum_Topic, Forum_Forum and if there are archived topics you will need to do it in tables for archived topics and replies as well. |
|
|
|
Lucky
Junior Member
USA
127 Posts |
Posted - 05 January 2003 : 17:23:49
|
i need to change three member's member_id. they have 1400, 300, and 400 message posts.
how do i begin making these changes? currently, i do not know how to change the member_id in MS Access, it won't allow me.
quote:
Originally posted by Lucky
Background: We'd like to add the member's ID number in the author box.
Question: Is it possible to change the member_id of a member? We'd like to make the first 'real' member (member_id 3) become member_id 1.
When we open the database in MS Access and try to change the member_id, it will not allow it.
Thanks!
|
~Lucky |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 January 2003 : 17:30:26
|
Okay, Give me the following info for each
Current Details:
Member_ID, MemberName
How you Want them?
One question though, How is MemberID so important that you want to change them? This is for internal processing only. |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 05 January 2003 : 17:52:42
|
| I agree .... forget about the number, it is only used internally. There is no point worrying about changing it. If a member has 1400 posts, then you have an established forum, so why change now ? Why the sudden need to change ? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 January 2003 : 17:56:34
|
May I suggest that you create a new field, say MemberNumber, and then fill it up according to the order of the MemberId. Personally I hate the idea of changing the value of a primary key, and MemberID is really a field that results from the fact that we are using a database to keep the members details. If you want to "Number" your members should, IMHO, create a field dedicated to that purpose. Of course, you'd need to fill the new field for every new member, after registration.
I'm moving this to the MOD W/O Code forum. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 05 January 2003 17:57:27 |
|
|
|
Lucky
Junior Member
USA
127 Posts |
Posted - 05 January 2003 : 17:57:42
|
quote:
Originally posted by GauravBhabu
Okay, Give me the following info for each
Current Details:
Member_ID, MemberName
How you Want them?
Currently:
Member_ID 3 - Lucky
Member_ID 4 - Burnout
Member_ID 5 - IronMan
Would like them to be:
Member_ID 1 - IronMan
Member_ID 2 - Lucky (with same access as username "Admin")
Member_ID 3 - Burnout
The current username, Admin, can be removed if the username "Lucky" has the ability to change other Administrators.
quote:
One question though, How is MemberID so important that you want to change them? This is for internal processing only.
Good question. The members on the site want to have their own member number (example: AI#1434). We'd like to use the number from member_id and currently there would be no member #1, 2, or 3. |
~Lucky |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 January 2003 : 18:00:48
|
quote:
Originally posted by Lucky
Good question. The members on the site want to have their own member number (example: AI#1434). We'd like to use the number from member_id and currently there would be no member #1, 2, or 3.
Precisely because of this, you should not use Member_ID. You cannot control the value assigned to this field, since Access handles it automatically. For what you want, you should have a field that has values that you can specify. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
