[MSAccessProfessionals] ADODB.Connection not opening DB

I'm pulling my hair out - why isn't this code opening the DB the references are correct - so it the filename and location.  The code runs with no errors but the DB is not opened.  It's 2007 Access and I'd like to say with ADO because of other reasons.

Any help would be appreciated - AI was not help :)

Private Sub Number3_Click()

 

    On Error GoTo OOPS

        

    Dim TestConn As ADODB.Connection

 

    Set TestConn = New ADODB.Connection

    TestConn.Provider = "Microsoft.Jet.OLEDB.4.0"

        

        TestConn.Open "C:\Junk\Tester1.MDB"

 

OOPS:

    MsgBox ("Sorry, Test3 not working")

 

End Sub

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116605) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_