Print Page | Close Window

Access Database Migration Tool

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=2810
Printed Date: 01 April 2026 at 6:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Access Database Migration Tool
Posted By: theSmoker
Subject: Access Database Migration Tool
Date Posted: 18 May 2003 at 2:32am

i have tried and tried to convert my wwf 7 b3 to wwf 7.01 using this tool and I can not get it to work!!

i have used compact and repair and still nothing happens 

i get a popup window using this tool:
enter parameter value
status

what is this?

 




Replies:
Posted By: WebWiz-Bruce
Date Posted: 18 May 2003 at 2:42am

The upgrade tool is from version 6.x to version 7

There are no upgrades from the beta version to the full version 7 as beta versions where available for testing only and not for use on live web sites.

To upgrade your beta database you will have to go through the version history file and try and recreate all the new fields, tables, default values, etc in your database.



-------------
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: Trevni
Date Posted: 18 May 2003 at 4:30am
Originally posted by theSmoker theSmoker wrote:

i have tried and tried to convert my wwf 7 b3 to wwf 7.01 using this tool and I can not get it to work!!


i have used compact and repair and still nothing happens 


i get a popup window using this tool:
enter parameter value
status


what is this?


 



Now you come here and complain when Borg has mentioned thousands of times for people not to use the beta forums on live websites or this might happen. He does not post these warning for his own health.

-------------
Resident immature brat...


Posted By: theSmoker
Date Posted: 18 May 2003 at 2:25pm

sorry i was too impatient !! 

i have the database updated, but have this:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CInt'

what does this mean?

thanks to everyone that has helped me in solving the problems i am having!!

 



Posted By: fernan82
Date Posted: 18 May 2003 at 2:54pm
It means that some of the new fields have a <NULL> value, you'll have to go thru your db and all the new fields that are <NULL> change them to the default value which is 0

-------------
FeRnAN
http://www.danasoft.com/">


Posted By: theSmoker
Date Posted: 18 May 2003 at 3:42pm

Originally posted by fernan82 fernan82 wrote:

It means that some of the new fields have a <NULL> value, you'll have to go thru your db and all the new fields that are <NULL> change them to the default value which is 0


fernan82 or anyone...,

i have looked over my database twice, and can not find any fields with "<null>"

there are some with "now()" tho!

what am i doing wrong?
can you or someone explain what i need to do..please!

thanks for your help!!



Posted By: theSmoker
Date Posted: 18 May 2003 at 7:06pm
Originally posted by theSmoker theSmoker wrote:

Originally posted by fernan82 fernan82 wrote:

It means that some of the new fields have a <NULL> value, you'll have to go thru your db and all the new fields that are <NULL> change them to the default value which is 0


fernan82 or anyone...,

i have looked over my database twice, and can not find any fields with "<null>"

there are some with "now()" tho!

what am i doing wrong?
can you or someone explain what i need to do..please!

thanks for your help!!

anyone??

i did a search for word, phrase for this error and results came up with nothing....this is a bummer for a "newbie" 

 



Posted By: xeerex
Date Posted: 18 May 2003 at 7:23pm

Correct my Fernan but <Null> means nothing in the field right? If so, then theSmoker needs to look for fields that have nothing in the default value and enter whatever.

Here's a suggestion. Take a look at the v7.01 tables/fields and duplicate that in your v7b3 database if the revision history is not helping you. I haven't tried it, but I bet you could do some import/export from the v7b3 database to the v7.01 database to move the data. It'd take a little work but I bet it could happen.



-------------
http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers?
http://www.smartergeek.com - web design | pc support | training | podcasts | video production


Posted By: theSmoker
Date Posted: 19 May 2003 at 12:09am
Originally posted by xeerex xeerex wrote:

Correct my Fernan but <Null> means nothing in the field right? If so, then theSmoker needs to look for fields that have nothing in the default value and enter whatever.

Here's a suggestion. Take a look at the v7.01 tables/fields and duplicate that in your v7b3 database if the revision history is not helping you. I haven't tried it, but I bet you could do some import/export from the v7b3 database to the v7.01 database to move the data. It'd take a little work but I bet it could happen.

 

xeerex..

i have tried your suggestion and i still can not figure this out!
i am a newbie and all this is "strange" to me!

i might as well give up on it, because no one can explain this in simple terms/words

thanks for your input



Posted By: Zamal
Date Posted: 19 May 2003 at 3:57am

If you take a look at the version history you'll see the following database changes between 7.0 beta 3 and 7.01. My advice is to check the ones in red to see if you've done them correctly

1. tblGuestName - new table to hold the names of guest posters if guest posting is enabled
2. tblAuthor - added the following fields
 Real_name - text datatype 40 char
 Avatar_title - text datatype 50 char
3. tblGroup - new table - Custom_stars - text datatype 80 chars
4. wwfSpThreadDetails - changed strored procedure in SQL server version
5. tblPoll - new field - Author_ID - interger datatype
6. tblConfiguaration - added the following tables
 Upload_avatar - true/false datatype
 Upload_avatar_path - text datatype 50 char
 Upload_avatar_types - text datatype 50 char
 Upload_avatar_size - interger datatype
 Reg_closed  - true/false datatype
7. tblForum new field - Moved_ID - interger datatype - default value 0
8. stored procedure tblTopicDetialsAll changed
9. stored procedure tblTopicDetialsInTheLastXX changed
1. tblPermissions - Author_ID field added, datatype interger - default value 0
2. wwfspForumPermisions - stored procedure changed to also grab individual user permissions for forums
3. wwfspMederators - new stored procedure to get the moderators for forums



Posted By: theSmoker
Date Posted: 22 May 2003 at 3:28am
Originally posted by Zamal Zamal wrote:

If you take a look at the version history you'll see the following database changes between 7.0 beta 3 and 7.01. My advice is to check the ones in red to see if you've done them correctly

1. tblGuestName - new table to hold the names of guest posters if guest posting is enabled
2. tblAuthor - added the following fields
 Real_name - text datatype 40 char
 Avatar_title - text datatype 50 char
3. tblGroup - new table - Custom_stars - text datatype 80 chars
4. wwfSpThreadDetails - changed strored procedure in SQL server version
5. tblPoll - new field - Author_ID - interger datatype
6. tblConfiguaration - added the following tables
 Upload_avatar - true/false datatype
 Upload_avatar_path - text datatype 50 char
 Upload_avatar_types - text datatype 50 char
 Upload_avatar_size - interger datatype
 Reg_closed  - true/false datatype
7. tblForum new field - Moved_ID - interger datatype - default value 0
8. stored procedure tblTopicDetialsAll changed
9. stored procedure tblTopicDetialsInTheLastXX changed
1. tblPermissions - Author_ID field added, datatype interger - default value 0
2. wwfspForumPermisions - stored procedure changed to also grab individual user permissions for forums
3. wwfspMederators - new stored procedure to get the moderators for forums

zamal or others..

i follow the above and checked it over, making sure it was spell and put in correctly!
it is all there, but i am getting this error 

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/forum_topics.asp

any help on this is grealtly appreciative

(this is getting very  frustrated to me and to others..ehh?)

 



Posted By: WebWiz-Bruce
Date Posted: 22 May 2003 at 3:41am

You need to make sure the new fields in the database has been set for the correct datatype and default value.

Fields like moved_ID should contain a value in every field, if you didn't give it a default value when creating this field you will have to go through the database and enter 0 in every record.



-------------
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: theSmoker
Date Posted: 22 May 2003 at 9:11pm
Originally posted by -boRg- -boRg- wrote:

You need to make sure the new fields in the database has been set for the correct datatype and default value.

Fields like moved_ID should contain a value in every field, if you didn't give it a default value when creating this field you will have to go through the database and enter 0 in every record.

borg (or anyone that wants to help)..

remember i am a newbie to all this and please be patient as well as others that want to help me!

the moved_id has a default value of 0 and i am still getting this error 

what is the default value for the new fields?

do i put a 0 as the default value in every field or what?

thanks

 



Posted By: theSmoker
Date Posted: 23 May 2003 at 11:37am

i guess that i am asking tooo much!! 

thanks to all that helped me!!

 



Posted By: theSmoker
Date Posted: 24 May 2003 at 10:31pm

ok folks here is my problem...maybe

i am inserting tables as fields!

how do you make a table?

for example:
tblGroup - new table - Custom_stars - text datatype 80 chars

remember..i am a newbie and simple instructions..please! 

thanks


 



Posted By: Zamal
Date Posted: 25 May 2003 at 3:48am
The easiest way to insert the new table in your 7 beta 3 database would be by opening both your database and the default 7.01 database in Acces (I'm assuming that's what you use). Select the new tables in the 7.01 database and copy / paste them to your own database.


Posted By: theSmoker
Date Posted: 26 May 2003 at 10:27pm

Originally posted by Zamal Zamal wrote:

The easiest way to insert the new table in your 7 beta 3 database would be by opening both your database and the default 7.01 database in Acces (I'm assuming that's what you use). Select the new tables in the 7.01 database and copy / paste them to your own database.

 

easy said than doing!! 
i have tried everything that everone suggested, but still no go!

 




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net