Web Wiz Forums - Microsoft JET Database Engine error ’8004

Print Page | Close Window

Microsoft JET Database Engine error ’8004

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=2354
Printed Date: 31 March 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Microsoft JET Database Engine error ’8004

Posted By: dgulbransen
Subject: Microsoft JET Database Engine error ’8004
Date Posted: 02 May 2003 at 1:29am

I get this, + the other people on my forum get this msg when posting sometimes. They loose their entire post.

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.

/post_message.asp, line 749

Is this a common error? Is there anyway to fix it?

http://forums.centralchat.net - http://forums.centralchat.net << forums

Replies:

Posted By: WebWiz-Bruce
Date Posted: 02 May 2003 at 4:56am

Looks like your database maybe corrupted, or if you updated from a previous version then there is a problem with it.

Try downloading the database and compacting and repairing it in Access. You'll find it under the tools menu in access.

-------------
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: dgulbransen
Date Posted: 02 May 2003 at 10:09pm

ok i will try that

Posted By: dgulbransen
Date Posted: 04 May 2003 at 6:56pm

See, I migrated from version 6 to 7. There were no error msg's.

Then I did the compact/repair.

Anyways, I did the compact/repair thing again

The error still comes up every once and a while!

I don't know what to do, it's really becomming a problem!