ADO recordset and Filter problem

A

Andrius

Hi,

My install is:
Access 2000, SP3; Jet 4.0 SP8; MDAC 2.7

Explanation of my situation:

I am setting recordset for my Access 2000 form like this:

oCmd.ActiveConnection = ...
oCmd.CommandType = adCmdStoredProc
oCmd.CommandTimeout = 0
oCmd.CommandText = "spMySP"

RS.Open oCmd, , adOpenKeyset, adLockBatchOptimistic

Set Me.fsuDetails.Form.Recordset = RS

Everything works well, but,
after applying filter (filter by selection)
on that form I can't anymore operate on form
recordset object. Any operation with form recordset causes
"ActiveX component can't create object" error message.
Removing filter by pressing toolbar button - doesn't help
- any operation on recordset shows error,
even more, sometimes Access 2000 crashes.

After closing and reopening that recordset - everything is OK.
(of course - filter removing occurred).

Is this Access 2000 bug or ADO bug - does anybody encountered such a
situation ?

Regards,
Andrius.
 

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

ADO Recordset as Form's Data Source - Removing a Filter Raises Error 3
Filter not re-activating 0
OWC11 chartspace with a recordset in asp, and error 80004005 3
set unbound listbox recordset to sorted and filtered ADO recordset 0
Cannot update a disconnected (and then re-connected) ADO recordset bound to Access 2003 form 5
ADO exporting to Excel- read only error 2
ADO Recordset Problem 2
Binding MS Access form to ADO recordset: Invalid use of property 2

Top