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()
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