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: 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
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... |
theSmoker wrote:Posted By: theSmoker
Date Posted: 18 May 2003 at 2:25pm
|
sorry i was too impatient !! i have the database updated, but have this: 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
|
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? thanks for your help!! |
Posted By: theSmoker
Date Posted: 18 May 2003 at 7:06pm
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
xeerex.. i have tried your suggestion and i still can not figure this out! 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 |
Posted By: theSmoker
Date Posted: 22 May 2003 at 3:28am
zamal or others.. i follow the above and checked it over, making sure it was spell and put in correctly! 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
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: 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
|
easy said than doing!!
|