Web Wiz Support and Community Forums : from Access to MSSQL version

Web Wiz Support and Community Forums : from Access to MSSQL version https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 18:57:37 +0000 Mon, 07 Apr 2008 14:57:08 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25516 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[from Access to MSSQL version : I would use Access 2007 for this...]]> https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132475.html#132475 Author: WebWiz-Bruce
Subject: 25516
Posted: 07 April 2008 at 2:57pm

I would use Access 2007 for this as it is much more successful than other versions and not yet seen it fail, so couldn't comment on why you got these errors.]]> Mon, 07 Apr 2008 14:57:08 +0000 https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132475.html#132475 <![CDATA[from Access to MSSQL version : Hi Bruce! I did this but I've...]]> https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132472.html#132472 Author: sunrise69
Subject: 25516
Posted: 07 April 2008 at 2:42pm

Hi Bruce!

I did this but I've got a few errors:

tblAuthor: Table was skipped or export failed

tblCategory: Table was skipped or export failed

tblForum: Table was skipped or export failed

tblGroup: Table was skipped or export failed

Are there any important options in Upsizing Wizard? This's the first time I use it.

I try to upgrade to existing SQL Server database that already has some forums.

Thank you in advance!

]]> Mon, 07 Apr 2008 14:42:54 +0000 https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132472.html#132472 <![CDATA[from Access to MSSQL version : Thanks a lot! ]]> https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132312.html#132312 Author: sunrise69
Subject: 25516
Posted: 02 April 2008 at 11:39am

Thanks a lot!]]> Wed, 02 Apr 2008 11:39:40 +0000 https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132312.html#132312 <![CDATA[from Access to MSSQL version : There are database upgrade tools...]]> https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132311.html#132311 Author: WebWiz-Bruce
Subject: 25516
Posted: 02 April 2008 at 11:34am

There are database upgrade tools to upgrade your Access database to version 9.x. These tools are found in the Web Wiz Forums download zip file.

Once you have upgraded your Access forum use the 'Upsize Wizard' in MS Access to Upsize the database to SQL Server. The one in Access 2007 is really good and use it quite often to move Web Wiz Forums Access databases to SQL Server.
]]> Wed, 02 Apr 2008 11:34:28 +0000 https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132311.html#132311 <![CDATA[from Access to MSSQL version : Hi everybody! I want to upgrade...]]> https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132304.html#132304 Author: sunrise69
Subject: 25516
Posted: 02 April 2008 at 6:36am

Hi everybody!

I want to upgrade from 7.x (Access) to 9.x (MSSQL), but I need to save all my post and user data. Did anybody do this? What was problem?

]]> Wed, 02 Apr 2008 06:36:29 +0000 https://forums.webwiz.net/from-access-to-mssql-version_topic25516_post132304.html#132304