Converting from Access 7 to SQL 8.3

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

Edited by Ryanvdm - 27 July 2006 at 11:14am