Web Wiz Forums - Deleted "Guest User"

Print Page | Close Window

Deleted "Guest User" - howto undo this

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=20239
Printed Date: 11 April 2026 at 2:47pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Deleted "Guest User" - howto undo this

Posted By: leiti
Subject: Deleted "Guest User" - howto undo this
Date 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.

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
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: leiti
Date 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.

Posted By: WebWiz-Bruce
Date 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.

-------------
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: leiti
Date 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