Import Tool fails after 176 records
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=26045
Printed Date: 03 April 2026 at 11:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Import Tool fails after 176 records
Posted By: jadam
Subject: Import Tool fails after 176 records
Date Posted: 31 July 2008 at 6:10pm
|
I am unable to get the access 2000 import tool to work (full, paid version). It starts fine then fails at 176 records (out of 760). The error that is displayed on the page is this:
Microsoft OLE DB Provider for SQL Server error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /forum/admin_import_members.asp, line 427 If I try it again (assuming that it will ignore duplicate records), the import gets thru about 15 records and I get this error message:Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert duplicate key row in object 'dbo.tblAuthor' with unique index 'Username'. /forum/admin_import_members.asp, line 454 Does anyone have any suggestions?
Thanks,
Joe |
Replies:
Posted By: 123Simples
Date Posted: 31 July 2008 at 7:14pm
|
It would appear to me, that if you click on your homepage link that it is screwed up because your link actually reads: http://forums.webwiz.net/www.cybermedics.net Which is no wonder why your forum is not working correctly ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Scotty32
Date Posted: 31 July 2008 at 7:36pm
|
TWS, his homepage link has nothing to do with his forum - he just forgot to add the "http://" in his profile. As for the first error, Im not sure but I think it might have something to do with a username or password is too long? Second error is actually because of a duplicate username - either you have two users with the same name - or the its trying to readd the same users. ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
Posted By: jadam
Date Posted: 31 July 2008 at 7:38pm
|
Huh? What in the world are you talking about? My profile link? I'll check that....
The forum is located at http://www.acvpm2.org/forum/default.asp - http://www.acvpm2.org/forum/default.asp
The forum works fine.... It's the Import Tool that doesn't work....
Joe
|
Posted By: MadDog
Date Posted: 31 July 2008 at 7:42pm
|
jadam, read what Scotty wrote. He gave you the answer to the problem.
------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: jadam
Date Posted: 31 July 2008 at 8:16pm
|
Thanks Scotty, that was part of the problem, another was a FK mistake I made.
All records imported properly!
Joe
|