Web Wiz Support and Community Forums : Deleted "Guest User" - howto undo this https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 14:49:43 +0000 Fri, 09 Jun 2006 15:01:24 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20239 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Deleted "Guest User" - howto undo this : For all people with the same problem...]]> https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108758.html#108758 Author: leiti
Subject: 20239
Posted: 09 June 2006 at 3:01pm

For all people with the same problem - here is the simple solution:
 
Import a new Author table as tblauthor1 to your database.
 
Run the following SQL Statement:
 
INSERT INTO tblAuthor (Author_ID, Group_ID, Username, Password, User_Code, Time_offset, Time_offset_hours)
SELECT Author_ID, Group_ID, Username, Password, User_Code, Time_offset, Time_offset_hours
FROM tblAuthor1
WHERE (([tblAuthor1].[Author_ID]=2));
 
this will insert the guest user with Author_ID = 2
]]> Fri, 09 Jun 2006 15:01:24 +0000 https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108758.html#108758 <![CDATA[Deleted "Guest User" - howto undo this : You will need to find a way to...]]> https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108746.html#108746 Author: WebWiz-Bruce
Subject: 20239
Posted: 09 June 2006 at 1:11pm

You will need to find a way to turn off the auto-numbering so you can enter a guest account with the ID of 2

This is hardcoded into the forum, and if you can not find away to do this certain features within your forum will not run.
]]> Fri, 09 Jun 2006 13:11:45 +0000 https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108746.html#108746 <![CDATA[Deleted "Guest User" - howto undo this : Thanks, I use Access 2003. I...]]> https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108736.html#108736 Author: leiti
Subject: 20239
Posted: 09 June 2006 at 10:05am

Thanks,
 
I use Access 2003.
 
I tried to change the fieldtype from counter to number and insert guest user with ID 2, but changen the fieldtype is not possible.
 
So I tried to delete the relationship between the author and the two other tables, but when I tried to make a new relationship, i was not able to do this.
 
Thanks for your help.
]]> Fri, 09 Jun 2006 10:05:39 +0000 https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108736.html#108736 <![CDATA[Deleted "Guest User" - howto undo this : This is a big problem, and unless...]]> https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108733.html#108733 Author: WebWiz-Bruce
Subject: 20239
Posted: 09 June 2006 at 9:43am

This is a big problem, and unless you are good with database could be difficult to undo.

If you tell me what database version you are using I should be able to give you some tips on how to directly edit the database to fix this issue.
]]> Fri, 09 Jun 2006 09:43:40 +0000 https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108733.html#108733 <![CDATA[Deleted "Guest User" - howto undo this : Hello, i just have deleted...]]> https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108722.html#108722 Author: leiti
Subject: 20239
Posted: 09 June 2006 at 8:43am

Hello,
 
i just have deleted my "Guest" User from the Access database.
Now posting as Guest is not possible anymore. (I know my fault ...)
 
Is there any way, to "undo" this, which mean to insert a new guest user?
 
Thanks for your help.
]]> Fri, 09 Jun 2006 08:43:04 +0000 https://forums.webwiz.net/deleted-guest-user-howto-undo-this_topic20239_post108722.html#108722