VBA Open Access database

[jakobt]

Getting a compile error: User defined type not defined

Sub connecttoDB()


Dim accessconn As accdb.Connection


Set accessconn = New accdb.Connection


accessconn.connectionstring = "provider=microsoft.ace.olebd.12.0;data source = S:\WL.accdb"


accessconn.Open


End Sub

 

[Joe4]

Shouldn't it be "ADODB.Connection"?
Also, make sure that you have the appropriate library references selected.
See: https://analysistabs.com/excel-vba/ado-sql-macros-connecting-database/