Howdy, Stranger!

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

Categories

ADODB / DSN / Access Problems

ZemectrinZemectrin Member Posts: 1
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection
cn.ConnectionSting = "DSN=TimeOff"
cn.Open

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,
Zemectrin

Comments

  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    ____ // http://forcoder.org // free video tutorials and ebooks about / Delphi Ruby Swift JavaScript PHP Visual Basic .NET C++ Perl Python Assembly C Objective-C C# Java Visual Basic MATLAB Scratch Go R PL/SQL Erlang Alice Awk SAS ABAP FoxPro F# Prolog LabVIEW Clojure Lua Ada Dart Fortran Lisp D VBScript Julia Bash Scheme Scala Transact-SQL Logo Rust Hack Kotlin Crystal COBOL Apex ML / ___

Sign In or Register to comment.