Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    97 Code in 2000? (Access 97 & 2000)

    I had code that ran fine in 97, but during conversion to 2000, I'm getting lots of compile errors. Do I HAVE to reinvent the wheel? Is there any way I can run that 97 code in 2000?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: 97 Code in 2000? (Access 97 & 2000)

    In general, code from 97 will run in 2000, but there are some gottcas. Some old code originating in Access 2.0 would run in Access 97, but won't in 2000. Unless that's the case, you may have a references problem where you need to have DAO 3.6 available and 2000 is trying to use ADO instead. But we have converted numerous 97 databases with only a few changes required. Good luck.

    Wendell
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 97 Code in 2000? (Access 97 & 2000)

    The usual problem relates to ADO and DAO. Access2000 uses ADO by default. One way around this problem is to remove the reference to the ADO library. Or, you can specify DAO when you declare your variables as in :
    Dim rs as DAO.recordset
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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