Version 8 Access 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=19738
Printed Date: 11 April 2026 at 1:21pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Version 8 Access to SQL?
Posted By: balearicjobs
Subject: Version 8 Access to SQL?
Date Posted: 06 May 2006 at 1:42pm
Hi  Hope this hasn't already been covered.I have recently purchased this excellent piece of software after nearly 3 years of use and I am proud to say that I have now got over 14,000 members. I have up until now been using the v7.2 version Access, but I am now going to upgrade to the version 8. I have sucessfully installed a test copy of hte SQL version and it works fine and I have successfully upgrade my V7 Access to V8 access, however I am now very intrested in transfering to the SQL database to increase the speed. I have had a read though the posts on here and aplogises if it is there but I haven't been able to find clear instructions on how to switch a V8 Access forum over the SQL forum? Is it possible? And if so, how would I go about doing this? I should say that while I am gaining in confidence and have been running a sucessful website for 5 years, 3 of which I have had ASP applications installed, I am still somewhat a novice - which is actually one of the reason I choose to use WebWiz, with a bit of reading it is actually a very easy piece of software to manage. I really appreciate your assistance. Kind Regards Rob Balearic-Jobs.com Admin |
Replies:
Posted By: balearicjobs
Date Posted: 06 May 2006 at 6:00pm
 I just gave it a go...switching to SQL.... wow I failed big style! I was messing really, so I made backups of everything... I use 1&1 hosting whom apparently do not allowed this Enterprise Manager program that I see mentioned a lot, however they do have there own importing tool and also use "mylittletools.net" to admistrate SQL databases. I tried it as following, please feel free to call me an idiot if this is completly wrong!  I was running Access 2000 version of V7.2 I deleted everything but the database I uploaded Access 2000 - The Latest Version 8 I used the database update tool to bring my V7 database up to date The forum was now running version 8 Access 2000 without problems. Now I decided to try the switch to SQL In 1&1 control panel I started a new database. Once it was ready, deleted the Access 2000 version from the server, except the database I uploaded the SQL version I then editted the database_connection.asp file and pointed it at the new database I then ran the msSQL_server_setup.asp and entered the details in there, it seemed to complete without problems. I now had a blank v8 message board running from an SQL database I then went the 1&1 control panel and ran their MDB import program, this took a few minutes too complete but it reported that it had sucessfully imported the recently updated v8 access database into the new SQL database. I loaded the messageboard up and it all appeared great, all the topics where there and I could read all the topics. Then wham! I tried to post a new topic and I got an "Insert Fails" error, something about the column not accepting Nulls.Oh well, I have got V8 working but its the Access 2000 version... any ideas please? Thank you! |
Posted By: WebWiz-Bruce
Date Posted: 08 May 2006 at 10:03am
|
Never used 1&1's MDB import program, as from the large number of complaints and issues on this forum about 1&1, it's one host I would stay well clear of. However, it sounds like the problem is that the import program has not carried across the default values that are required for some fields. The main ones are all fields that have ID at the end, these fields need to be set as an IDENTITY field with a seed value of 1, so that the filed auto increments by 1 each time a new record is created. This is the same as auto-number in Access. ------------- 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: surfsd
Date Posted: 10 June 2006 at 3:27am
|
in mssql, when you import a table, there's a good chance the identity
columns are removed from the table definition and you need to reset
them.
------------- http://www.surfingsandiego.com/forum/default.asp - http://www.surfingsandiego.com/forum/default.asp |