[CallMeAndy]

I have an active connection I assume when an access database is open.

Can I then open a second connection to the same database using ADO.

I have a table where records are children of other records, in an indefinite number of levels.

On a continuous form; I have a checkbox that when clicked updates that records children's visibility. So enabling a tree like record structure where you can set and unset the visibility of a records children as and when required.

The process is not getting past the connection.open statement. It reports 3706 "Provider cannot be found....."

Private Sub ChildrenOpen_AfterUpdate()
DoCmd.RunCommand acCmdSaveRecord
SetChildrenVisibility
End Sub

Private Sub SetChildrenVisibility()
Dim rst As ADODB.Recordset
Dim strCriteria As String
Dim strMessage As String
Dim strRst As String
Dim mark As Variant
Dim cnn As ADODB.Connection


intCurRecord = Forms![tasks subform].TaskID

Set cnn = New ADODB.Connection

cnn.Provider = "Provider=Microsoft.Jet.OLEDB.4.0"
cnn.Open "y:\taskbase2.mdb", "admin", ""

.............