Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - access7.5 >> sql7.7 which pages ?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

access7.5 >> sql7.7 which pages ?
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
zadax View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 19 January 2003
Location: Israel
Status: Offline
Points: 433 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zadax Quote  Post ReplyReply Direct Link To This Post Topic: access7.5 >> sql7.7 which pages ?
    Posted: 28 April 2004 at 4:55am

i got planty mods on my forum now (the access 7.5ver) and i wana change to sql 7.7ver i wanted to know if i can keep the 7.5(access) asp files and just reupload the most needed sql asp files and the sql server db .

my qustion is which asp files most stay to run the sql 7.7 ver ?

 

(btw i searched in forums with no luck)
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: 28 April 2004 at 5:26am
The only thing you need to do is change the database type variable in the common.asp files and edit the SQL_server_connection.asp file found in the admin area to put in your MS SQL server details.

You will still need to download the MS SQL server version to get the MS SQL Server database setup file to create the database.

The only real problems you may encounter is that some of the mods you have installed may only run with Access so it maybe worth checking these mods are compatiable.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
zadax View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 19 January 2003
Location: Israel
Status: Offline
Points: 433 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zadax Quote  Post ReplyReply Direct Link To This Post Posted: 28 April 2004 at 5:45am

Originally posted by -boRg- -boRg- wrote:



You will still need to download the MS SQL server version to get the MS SQL Server database setup file to create the database.

but i alredy got the aceess db and its size 50mb+

its ver 7.5 db . 

i can make it to SQL db in Access program but it still work with ver7.7 sql ver ?
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: 28 April 2004 at 7:12am
Yes, the only thing that has changed in the SQL server version to do with the database is the stored procedures, the database structure and tables remain the same.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
zadax View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 19 January 2003
Location: Israel
Status: Offline
Points: 433 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zadax Quote  Post ReplyReply Direct Link To This Post Posted: 28 April 2004 at 7:41am

i dont know how to add the procedures menuly

but i know thers a file that adds the tabel / prudcers

can u plz edit it for me so it work with my old db

plz borg
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: 28 April 2004 at 8:13am
Just run the SQL database setup file, if a table alreay exists it will throw an error saying so, but the stored procedures will still be created.
Web Wiz Forums Hosting
ASP.NET Web Hosting
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.