Access Transaction Rollback causes Recordset cursor loss

B

Bryce Powell

Hi,

I am maintaining an Access 2000 SR-1 database that uses
linked tables to a SQL Server 2000 database. The recordset
of a subform dies when a workspace Rollback method is
called in the main form. Thereafter any code attempt to
access the recordset then gives an "Object invalid or no
longer set." (err# 3420)

KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;248968&Product=acc

refers to SR-1 for Office that needs to be installed. I do
have this service pack installed.

What could be causing this problem?

Thanks in advance,
Bryce Powell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Transaction Rollback problem 12
3034 You tried to commit or rollback a transaction 1
access and transactional commit/rollback 2
Binding MS Access form to ADO recordset: Invalid use of property 2
Access Switchboard not Working - Private Function HandleButtonClick 1
ADO Recordset .Findfirst anomaly (Access 2007 ACCDB front end) 1
MS ACCESS query returns empty recordset from odbc linked sql server tables 3
access 2003 execute after edit in same transaction causes error 3

Top