Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.ConnectionSting = "DSN=TimeOff"
I can't seem to get a connection to my access database (with the DSN name of 'TimeOff'). When I run the program it tells me that my 'User Defined Type' is 'Not Defined', and it points to 'cn As ADODB.Connection' as the error.
Is there a reference that I don't have set correctly? I've tried it with both the 'Microsoft ADO Ext. 2.1 for DLL and Security' and 'Microsoft DAO 3.51 Object Library' turned on, and I can't seem to get it to connect.
Any help would be appreciated,