Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting from 97 to 2003 (version 2003)

    I am in the process of converting 97 databases to 2003. I got an error message on the very first one. Lucky me!

    The conversion seemed to go flawless until I was ready to open the database. I am using a switchboard and I get an error message when try to load it. The de###### stops at the set dbs = currentDb () code. I went through my references and actived all the necessary ones but I must have missed something. It still tells me error in loading DLL.

    Any help would be appreciated.

    Deborah

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Converting from 97 to 2003 (version 2003)

    Hi Deborah

    Have you referenced the Microsoft DAO x.x Library? Also, make sure the reference to this library is moved as far up the list of reference libraries as it will go. You could try - Dim dbs As DAO.Database

    Just some ideas.
    Jerry

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Converting from 97 to 2003 (version 2003)

    Specifically make sure that the references to DAO is higher in the list than the reference to ADO.

    In 97 any declaration such as Dim db as database meant a DAO.Database.
    In 2000 (or later) it could be either DAO.database or ADO.Database.

    To be safe each declaration should say Dim db as DAO.database

    but the default is the first in the list of references. So putting DAO higher than ADO should fix it.
    Regards
    John



Posting Permissions

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