Urgent BUG

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
tomasr Members Profile Find Members Posts Newbie Joined: 17 October 2003 Status: Offline Points: 13	Post Options Post Reply Quote tomasr Report Post Thanks(0) Quote Reply Topic: Urgent BUG Posted: 20 October 2003 at 3:40am
	Hello, I am using Web Wiz Forums version 7.5. And sometimes error appears then I want to post new potic Microsoft JET Database Engine error '80040e21' The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. /scripts/forum/post_message.asp, line 756

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: 20 October 2003 at 4:53am
	You haven't said if this is a update from a previous version or when exactly this error occurs to be able to replicate it. eg. what you are posting? what options you are selecting? what language you are posting? It could also be a corruption in the access database, try compacting and repairing the database from the admin section.
	Web Wiz Forums Hosting ASP.NET Web Hosting

tomasr Members Profile Find Members Posts Newbie Joined: 17 October 2003 Status: Offline Points: 13	Post Options Post Reply Quote tomasr Report Post Thanks(0) Quote Reply Posted: 20 October 2003 at 5:53am
	I have updated forum db from 6 to 7 version with "Access Database Migration Tool" tools. I also have tryied to repair db but no luck.

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: 20 October 2003 at 6:07am
	Sounds like the upgrade has not worked correctly. You need to compact and repair both databases before and after the update in Access. The compact and repair tool can be found under the tools menu in access.
	Web Wiz Forums Hosting ASP.NET Web Hosting

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

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.