Results 1 to 2 of 2
  1. #1
    jdashm is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2016
    Posts
    58

    ADODB.recordset Not Defined Error


    I recently converted an Access mdb file to Access 2016.
    When I run a particular report I get a dialog box with the message...

    Compile Error
    User-Defined type not defined

    The code highlighted is this declaration...
    Dim rst As New ADODB.Recordset

    This error did not exist in the older version so I tend to think it is a VB Library reference or old coding.
    Can anyone help me correct this.

    Thanks in advance.

  2. #2
    Micron is online now Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    check your references in the vb editor and see if any are marked missing, or that you do have a reference to ADO (ActiveX Data Objects).
    Seems that M$ decided ADO wasn't the big thing they thought it would be and have reversed course. DAO is the default in later versions.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change ADODB.Recordset by New
    By Remphan in forum Programming
    Replies: 1
    Last Post: 03-15-2016, 07:31 AM
  2. Error Handling with ADODB Recordset Object
    By Aaron5714 in forum Programming
    Replies: 3
    Last Post: 12-27-2012, 04:02 PM
  3. Replies: 1
    Last Post: 12-14-2012, 12:32 AM
  4. Replies: 4
    Last Post: 06-08-2012, 09:08 AM
  5. Replies: 2
    Last Post: 03-08-2012, 12:59 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums