Web Wiz Forums - problem upgrading from access to sql

Print Page | Close Window

problem upgrading from access to sql

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=25865
Printed Date: 03 April 2026 at 11:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: problem upgrading from access to sql

Posted By: Gilman
Subject: problem upgrading from access to sql
Date Posted: 20 June 2008 at 3:42am

I am having a problem upgrading from a version 7 access version of the web wiz software to the newest version SQL version. I have the forum working with SQL with a blank DB, but I would like to add info from the previous version to the new forum.

I am trying to use the upsize tool in access. Is there another way?

Thanks,

Gil

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 June 2008 at 8:45am

You should need to upgrade your present 7.x Access database to a 9.x database using the database upgrade tools that come with Web Wiz Forums.

You then need to use the upsize wizard in Access to upsize the Access database to SQL Server. The best results I have had have been with the Access 2007 upsize tool and have upsized many Web Wiz Forums databases using this tool without issue.

-------------
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: Gilman
Date Posted: 21 June 2008 at 7:19pm

Hey there Bruce! Good to see you here on the intarweb. We spoke at length on the phone yesterday and the day before.

I did get the forum working (for the most part). For one reason or another I am receiving an error when trying to make new posts though. Here is the error...

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CLng'

/forum/forum_posts.asp, line 856

Does this mean anything to you?

Thanks again for all your help!

Gil