Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Access Database Migration Tool
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Access Database Migration Tool

 Post Reply Post Reply Page  123>
Author
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post Topic: Access Database Migration Tool
    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?

 



Edited by theSmoker
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
Trevni View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 149
Post Options Post Options   Thanks (0) Thanks(0)   Quote Trevni Quote  Post ReplyReply Direct Link To This Post 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...
Back to Top
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post 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!!

 

Back to Top
fernan82 View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 17 November 2002
Location: United States
Status: Offline
Points: 362
Post Options Post Options   Thanks (0) Thanks(0)   Quote fernan82 Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post 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!!



Edited by theSmoker
Back to Top
theSmoker View Drop Down
Newbie
Newbie


Joined: 20 February 2002
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSmoker Quote  Post ReplyReply Direct Link To This Post 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" 

 

Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
 Post Reply Post Reply Page  123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.