register.asp error

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
SPman Members Profile Find Members Posts Newbie Joined: 12 June 2006 Status: Offline Points: 5	Post Options Post Reply Quote SPman Report Post Thanks(0) Quote Reply Posted: 13 June 2006 at 9:24am
	Hmm... This is very strange though. I am running IIS 5.0 on an XP machine (localhost) for testing. Also my external hosting company runs IIS 4 Windows 2000 and both give the same error. If it was just the one server I may be inclined to agree that it is limited to a small number of people. Also I installed MDAC 2.8 on my localhost, rebooted, retested a registration and the same error still occurs. However, I just tried installing the original database from this site, and now the error isnt occuring. Either the database is corrupted or perhaps the referigal integrity isnt what it should be. As far as getting a clean database for v8.02. how do I go about doing this? Cheers Edited by SPman - 13 June 2006 at 10:28am

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: 13 June 2006 at 11:56am
	Now were getting somewhere, I couldn't understand why this error should suddenly come about after using the same method on that file for 4 or 5 years. It sounds like the database may have become corrupted, and this is why you are getting this error. Access is a desktop file and not really up to being the backend for a forum, unless you only expect a handful of users. Because of this database corruption with Access databases is common, and although I do try a persuade people to use mySQL or SQL Server, people for some reason still like to use Access because of it's simplicity. What you will need to do is download your Access database, open it in Access, and then select 'Compact and repair database' from the tools menu. This should fix the issue with your database.
	Web Wiz Forums Hosting ASP.NET Web Hosting

SPman Members Profile Find Members Posts Newbie Joined: 12 June 2006 Status: Offline Points: 5	Post Options Post Reply Quote SPman Report Post Thanks(0) Quote Reply Posted: 13 June 2006 at 12:53pm
	I tried compact and repair didnt seem to fix the problem. Although I am starting from fresh with only one message posted so far so its no big problem for me to start again from scratch with the database from the download section of the site. It may be that for some unknown reason the latest database issued for v 8.02 corrupts a little easier, hence why there is a couple of people with the same problem. I admittedly messed around with the members to delete them from the database using the access user interface, and may have corrupted it in doing so. Edited by SPman - 13 June 2006 at 12:56pm

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: 13 June 2006 at 1:23pm
	It could be that you downloaded the first Access version of 8.02. Till the start of the month files had to be transferred from place to place and PC to PC, this coursed all sorts of problems including incorrect files getting into download zip files. This meant that the original Access 8.02 version somehow got a test Access database in the zip file which was full or crap that shouldn't be there. Although I hadn't realised this would course any problems apart from having to delete some data from the database. I have since updated the zip file with a clean fresh Access database in the form it should be. I have also now setup a Small Business Server 2003 so that all files are centrally located which will prevent having to move files around from PC to PC, which should prevent problems like this happening again, and will also hopefully speed up work flow, due to amount of times disks etc. have been lost, over written, etc. and work being lost. With a clean database you should have 2 members in the tblAuthor table, the 'Administrator' and the 'Guest' accounts, if either of these 2 built in accounts are deleted it can course errors. It maybe you accidentally deleted or altered one of these built in accounts coursing the problems you experienced.
	Web Wiz Forums Hosting ASP.NET Web Hosting

SPman Members Profile Find Members Posts Newbie Joined: 12 June 2006 Status: Offline Points: 5	Post Options Post Reply Quote SPman Report Post Thanks(0) Quote Reply Posted: 13 June 2006 at 2:00pm
	Thanks for this, I may well have. Hopefully this thread will have cleared things up for a few people though. No probs now.

Post Reply	Page <12

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