Changed username but srange happenings...
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13857
Printed Date: 12 April 2026 at 4:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Changed username but srange happenings...
Posted By: bims
Subject: Changed username but srange happenings...
Date Posted: 17 February 2005 at 5:42am
|
Right, greetings to all! I changed a username this morning and now it's playing up on my. Bascially the new username starts with a C but when the member list is arranged in alphabetical order it comes on top, and when i run a search for the username it cannot be found even though it appears on the memberlist. I've tried putting a space in front of the username when searching but that has not helped. So i can see it but cannot make changes to it. Anyone experienced this before? TIA Bims |
Replies:
Posted By: bims
Date Posted: 17 February 2005 at 8:33am
|
I downloaded the db and the username field for that person appeared blank. I typed in the new username and uploaded the database. Now it's showing the username twice eg "username username". If i search for 'use' for eg it brings up "username username" which i select from the dropdown box and it changes back to "username" Then it tells me that it cannot find any such user. ??? |
Posted By: WebWiz-Bruce
Date Posted: 17 February 2005 at 8:50am
|
Sounds like a corrupted database which is common with Acess. Hopefully you can save it using the compact and repair tool in Acess, better still use SQL Server ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: bims
Date Posted: 17 February 2005 at 9:02am
Hmm, ok I'll try the compact and repair. Regarding SQL, i do have
access to SQL server as part of my hosting but i'm not quite sure how
it works...plus i'm using three of your applications (news, guestbook
and forum) and ideally i'd like all apps to be SQLed. I'm not
sure how this would work... 1 SQL database hold many databases apps?
sorry - i've never worked with SQL before  Are there straightforward tutorials regarding migration? I saw a thread that on this form where someone attempted to draw up the steps but it seems a few people where having errors. |
Posted By: bims
Date Posted: 17 February 2005 at 12:01pm
|
Compact and Repair worked. any tips on migrating to SQL? |
Posted By: WebWiz-Bruce
Date Posted: 17 February 2005 at 12:07pm
|
See the sticky topic in this forum.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |