Web Wiz Forums - Access to MS SQL

Print Page | Close Window

Access to MS 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=18550
Printed Date: 13 April 2026 at 1:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access to MS SQL

Posted By: GeorgeB
Subject: Access to MS SQL
Date Posted: 01 March 2006 at 2:50pm

Hi,

I'm updating my access db to ms sql db. I'm receiving this error, when i want to post a new message.

ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

/forum_/post_message.asp, line 608

Thank you.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 01 March 2006 at 3:10pm

This can happen if the migration process has not happened correctly.

Posted By: GeorgeB
Date Posted: 07 March 2006 at 1:28pm

Thank you -boRg-. I converted with access upsizing wizard. Now, i can post a message without any error. But , i can not enter admin panel. It forwards me to insufficient_permission.asp

Thank you.

Posted By: WebWiz-Bruce
Date Posted: 07 March 2006 at 2:32pm

Make sure that the common.asp file in the admin area is pointing to the new database and that your browser and site can use session variables.