Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - upgrade from old Access version to SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

upgrade from old Access version to SQL

 Post Reply Post Reply
Author
phaderus View Drop Down
Newbie
Newbie
Avatar

Joined: 09 September 2003
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote phaderus Quote  Post ReplyReply Direct Link To This Post Topic: upgrade from old Access version to SQL
    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?

Back to Top
Phat View Drop Down
Senior Member
Senior Member


Joined: 23 February 2003
Status: Offline
Points: 386
Post Options Post Options   Thanks (0) Thanks(0)   Quote Phat Quote  Post ReplyReply Direct Link To This Post Posted: 10 September 2003 at 1:23am
Do a search on access to sql it has been answered before.
Back to Top
b_bonnett View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Location: New Zealand
Status: Offline
Points: 275
Post Options Post Options   Thanks (0) Thanks(0)   Quote b_bonnett Quote  Post ReplyReply Direct Link To This Post 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, The Plane Gallery
Greetings From Christchurch
Back to Top
phaderus View Drop Down
Newbie
Newbie
Avatar

Joined: 09 September 2003
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote phaderus Quote  Post ReplyReply Direct Link To This Post 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

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

Back to Top
 Post Reply Post Reply

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.