Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Version 8 Access to SQL?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Version 8 Access to SQL?
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
balearicjobs View Drop Down
Groupie
Groupie
Avatar

Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 86 		Post Options Post Options   Thanks (0) Thanks(0)   Quote balearicjobs Quote  Post ReplyReply Direct Link To This Post Topic: Version 8 Access to SQL?
    Posted: 06 May 2006 at 1:42pm
Hi Smile 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
Back to Top
balearicjobs View Drop Down
Groupie
Groupie
Avatar

Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 86 		Post Options Post Options   Thanks (0) Thanks(0)   Quote balearicjobs Quote  Post ReplyReply Direct Link To This Post Posted: 06 May 2006 at 6:00pm
LOL

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

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


Edited by balearicjobs - 06 May 2006 at 6:01pm
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: 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
surfsd View Drop Down
Newbie
Newbie


Joined: 10 June 2006
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote surfsd Quote  Post ReplyReply Direct Link To This Post 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.
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.