https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:23:46 +0000 Sat, 10 Jun 2006 03:27:41 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19738 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/version-8-access-to-sql_topic19738_post108794.html#108794 Author: surfsd
Subject: 19738
Posted: 10 June 2006 at 3:27am

in mssql, when you import a table, there's a good chance the identitycolumns are removed from the table definition and you need to resetthem.]]> Sat, 10 Jun 2006 03:27:41 +0000 https://forums.webwiz.net/version-8-access-to-sql_topic19738_post108794.html#108794 https://forums.webwiz.net/version-8-access-to-sql_topic19738_post106497.html#106497 Author: WebWiz-Bruce
Subject: 19738
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.
]]> Mon, 08 May 2006 10:03:02 +0000 https://forums.webwiz.net/version-8-access-to-sql_topic19738_post106497.html#106497 https://forums.webwiz.net/version-8-access-to-sql_topic19738_post106408.html#106408 Author: balearicjobs
Subject: 19738
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!


Edited by balearicjobs - 06 May 2006 at 6:01pm]]> Sat, 06 May 2006 18:00:20 +0000 https://forums.webwiz.net/version-8-access-to-sql_topic19738_post106408.html#106408 https://forums.webwiz.net/version-8-access-to-sql_topic19738_post106396.html#106396 Author: balearicjobs
Subject: 19738
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
]]> Sat, 06 May 2006 13:42:55 +0000 https://forums.webwiz.net/version-8-access-to-sql_topic19738_post106396.html#106396