Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    97 to 2000 upgrade - method/data member not found (2000 (9.0 SR-1))

    I'm lucky enough to be upgrading someone else's database from Access 97 to 2000, but am having problems with some of the VBA code. The de###### is giving me a "Method or Data Member Not Found" error on recordset .Findfirst and .nomatch methods. Which libraries need to be referenced to clear these errors. I've tried the Microsoft DAO's, but can't seem to find the right combination.

    Thanks!

    Larry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 97 to 2000 upgrade - method/data member not found (2000 (9.0 SR-1))

    If the database has been converted from Access 97, you probably use only DAO code, not ADO.
    In Tools/References... (from the Visual Basic Editor), uncheck all references (if present) to Microsoft DAO n.n Object Library and to Microsoft ActiveX Data Objects (any version). Click OK.
    Select Tools/References... again, check Microsoft DAO 3.6 Object Library, and click OK.
    Hopefully, you code now works.

    For future development, it is advisable to prefix all declarations of DAO objects, to prevent trouble when you want to add ADO code:

    Dim rst As DAO.Recordset
    Dim fld As DAO.Field
    Dim prm as DAO.Connection

    etc.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 97 to 2000 upgrade - method/data member not found (2000 (9.0 SR-1))

    Hans - thanks for the help - it was the evil ActiveX Objects that was eating my lunch. Larry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •