Access 2000 version
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=3300
Printed Date: 01 April 2026 at 12:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access 2000 version
Posted By: QiWiz13
Subject: Access 2000 version
Date Posted: 05 June 2003 at 9:08pm
|
I just updated from version 6 point something to version 7. Everything seems to work fine, except the new topic and new poll and post reply functions. For the new topic, it says that there is an errorin line 700-something of post_message.asp and says something about reformatting indices and tables. For the new poll, it's line 300-something and says that somethnig is out of range. Both the new topic and poll appears in the forum list of topics and polls, but when you click on them it says that there are no posts corresponding to it, and it's quite wierd. as far as i can tell, it's an error in an individual file. I've tried re-downloading and re-uploading the file but it doesn't change anything. [edit] ok the error thing for the new topic is: 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. /realm2/forum/post_message.asp, line 749 and for polls it is: Microsoft VBScript runtime error '800a0009' Subscript out of range: 'UBound' /realm2/forum/post_message.asp, line 392 ------------- 
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 06 June 2003 at 2:41am
|
It could be a corrupted file, try reuploading the files again. ------------- 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: xeerex
Date Posted: 06 June 2003 at 8:06am
|
I had that problem the first couple of times I migrated a forum to v7.x. Here is what I've found to be a sure-fire way to migrate on about 6 boards now:
That has worked on an Access database as large as 10,000 posts. If you have any more problems mailto:rex@rexpage.com?subject=Forum Upgrade - email me and I'll try to help you out. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: huwnet
Date Posted: 06 June 2003 at 11:52am
| I had this problem when I tryed moving the database user table! |
Posted By: QiWiz13
Date Posted: 06 June 2003 at 12:39pm
|
how exactly do i compact the the databases? -------------
|
Posted By: xeerex
Date Posted: 06 June 2003 at 1:07pm
|
The easy way is open it up in Access. Then click Tools...Database Utilities...Compact and Repair. There are some ASP scripts that will do it on the fly as well. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: QiWiz13
Date Posted: 06 June 2003 at 1:59pm
|
excellent, thanks alot, it works now, although I did something to the database that made it lose the posts and topics but that doesn't matter, it needed to be wiped anyways. Thanks! -------------
|