Deleted "Guest User" - howto undo this

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
leiti Members Profile Find Members Posts Groupie Joined: 16 February 2005 Status: Offline Points: 65	Post Options Post Reply Quote leiti Report Post Thanks(0) Quote Reply Topic: Deleted "Guest User" - howto undo this 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

leiti Members Profile Find Members Posts Groupie Joined: 16 February 2005 Status: Offline Points: 65	Post Options Post Reply Quote leiti Report Post Thanks(0) Quote Reply 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

leiti Members Profile Find Members Posts Groupie Joined: 16 February 2005 Status: Offline Points: 65	Post Options Post Reply Quote leiti Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum