ADODB / DSN / Access Problems

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,
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!