Web Wiz Forums - upgrade from old Access version to SQL

Print Page | Close Window

upgrade from old Access version 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=5644
Printed Date: 03 April 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: upgrade from old Access version to SQL

Posted By: phaderus
Subject: upgrade from old Access version to SQL
Date Posted: 09 September 2003 at 10:33pm

Does anyone know how I take an old forum that uses Access for its data, and convert it to use MS-SQL Server while keeping users and post, forrums, ets. I installed web wiz forum and set ot to use MS-SQL Server It fields are much different from the Access datatbase I currently have. For example, the Access database use the users password and stores it as reabable text, while the MS-SQL table encreyptes or encodes the password to something that is not readable to some looking at the database.

Am I trying to do something that can't be done?

Replies:

Posted By: Phat
Date Posted: 10 September 2003 at 1:23am

Do a search on access to sql it has been answered before.

-------------
http://buildit.sitesell.com/sitebuildithome.html - Get a website that sells

Posted By: b_bonnett
Date Posted: 10 September 2003 at 4:04am

Use the convertor available on the downloads page to upgrade your Access DB to the latest version, then upgrade to SQL.

Blair

-------------
Webmaster, http://www.planegallery.net/ - The Plane Gallery
Greetings From Christchurch

Posted By: phaderus
Date Posted: 10 September 2003 at 9:10am

I tried to convert access using the upgrade tool from the download I got an error message. A dialog box that says "Error 0:"

Does it make a difference that I am using the 6.11 version of web wizzard?

Any help would be truly appreciated

Posted By: WebWiz-Bruce
Date Posted: 10 September 2003 at 9:20am

There is no upgrade from 6.11.

You would have to go through the version history file and create all the new fields and tables manually.

-------------
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