Problem with databese?
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=1397
Printed Date: 30 March 2026 at 10:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Problem with databese?
Posted By: MariuszM
Subject: Problem with databese?
Date Posted: 27 March 2003 at 3:25am
|
Hi, I migrated my old Access Forum v6.34 into v.7.0 beta 4 by Access Database Migration Tool (ADMT). But now, if I want to get a new post or reply, I have an error " 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. /forum7/post_message.asp, line 750 "
------------- regards, MariuszM |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 27 March 2003 at 3:30am
|
Looks like it didn't work correctly. You need to compact and repair the old database first from the tools menu in access before trying to migrate the data to the new database, then do a compact and repair on the new database once the data is migrated. ------------- 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: WebWiz-Bruce
Date Posted: 27 March 2003 at 3:31am
|
Also it is strongly advised not to use beta versions on a live site as you may not be able to upgrade to the full version of version 7 once that is released. ------------- 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: MariuszM
Date Posted: 27 March 2003 at 3:49am
|
Yes, I know about it... I use beta version for testing new features of forum. ------------- regards, MariuszM |
Posted By: MariuszM
Date Posted: 27 March 2003 at 4:11am
|
Thanks, Borg... I did it what you said... and it works Thanks again. ------------- regards, MariuszM |
