I've upgrade from forum 6.5 to forum 7.6 . I've converted database but when I try t register a new user i receive this message:

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/register.asp, line 953

Why ?

thank you for the help, but I tried to Compacting / Repairing the database but I have the same error.

I've installed on my computer Access 2003 ,  is this the problem ?

Help , I can't start the new forum !!!!

Hi,

How did u upgrade the database ?

Go to admin menu -> then Compact & Repair Db -> then try.

if id does not work, check whether ur webhost has access 2k or earlier version. it must be 2k

I downloaded full forum version 7.6 from web site. Afterwards I used  "webwiz forum db migrator" to upgrade my old DB to new ( from 6.32 version to 7.6). I compacted offline (on my desktop) and online using  the admin function.

I can see all old messages and all  old users, I can modify their profiles but I can't register a new user.

there must be something wrong ! but where ?

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

try unset as primary key in the user table or something

I tried to unset the primary key of table TblAuthor, but this is impossible because this key has a lot of relationships with other tables!!!

hi, if u are using windows 2k3 or 2k, I think I know the problem,
well, it happened to me as well, not in this forum but in my own application I built I'm well known with this error,
the error could appear when you don't have a write/read or the IUSER_ account is not have the permission to the wwwroot or to your application main folder or sub folders that needs to interact with the database file, check if you have a read/write premissions on your main also sub folders! 
second the really important thing you should do is to add the user account "Internet Guest Account" (IUSER_) to your application folder and all his sub folder,
My Computer >> go to the folder you want to add the account right click then properties >> security >> add >>
advanced >> find now >> search for the user (IUSER_) >> OK >>
OK >> select the user (IUSER_) and allow him the permissions of:
Modify, Read & Execute, List Folder Contents, Read Write
deny the permission of Full control >> Advanced >>
check the box that says "Replace permission entries on all child objects with entries shown here that apply to child objects" >>
OK >> OK >> that's it!  it should work!
(My recommendation is to do it once on your IIS website directory default site direcotry for the IIS is wwwroot so u won't have a problem with other sites in the future).

If I use original db all is ok, when I upload the DB converted from 6.5 version I have this problem just during registration, otherwise when I modify the user profile all is ok.

is there counter that I must upgrade ?

Just for the record I've got what appears to be the same issue.

Hey thinked I've worked this one out.