Web Wiz Forums Modifications - Converting from Access 7 to SQL 8.3

Print Page | Close Window

Converting from Access 7 to SQL 8.3

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20836
Printed Date: 29 March 2026 at 4:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Converting from Access 7 to SQL 8.3

Posted By: Ryanvdm
Subject: Converting from Access 7 to SQL 8.3
Date Posted: 27 July 2006 at 11:13am

I have a 2 or 3 year old access database that i'm trying to switch to sql.

I have tried this every which way and the foolowing works the best.

I convert the old access database to the new using your conversion tool.

I then setup an SQL database and import all the tables directly from the updated access database using DTS.

Everything seems to work except i get this error.

on post or reply to new topic:

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_save_new_post_data
File Name:- new_post.asp

Error details:-
ADODB.Recordset
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

I have tried changing the locktype to 2 but to no avail.

any ideas would be appreciated.

thanks
Ryan