access7.5 >> sql7.7 which pages ?
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=10185
Printed Date: 08 April 2026 at 7:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: access7.5 >> sql7.7 which pages ?
Posted By: zadax
Subject: access7.5 >> sql7.7 which pages ?
Date 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) |
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- 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: zadax
Date Posted: 28 April 2004 at 5:45am
|
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 ? |
-boRg- wrote:Posted By: WebWiz-Bruce
Date 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.
------------- 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: zadax
Date 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 |
Posted By: WebWiz-Bruce
Date 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.
------------- 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 |