Compile error: Can't find catalog - But the reference isn't missing!

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Kathy
    #1

    Compile error: Can't find catalog - But the reference isn't missing!


    Hi All,
    I have several users who are getting a compile error "Can't find project
    or library when the code hits
    Dim cat as ADOX.Catalog

    In the references dialog box it show the msadox.dll as missing BUT it's
    in it's folder right where it belongs. I'v tried decompiling the
    database using the switch to no avail. The database runs fine on my
    machine. No one had any problems with it yesterday and nothing has
    changed.

    I could really use a suggestion!
    Thanks,
    Kathy


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • Wayne Morgan
      #2
      Re: Compile error: Can't find catalog - But the reference isn't missing!

      You will find a good description here on handling reference problems. If you
      create a new database does this reference still show Missing? If not, then
      try to import everything into the new file. If it does, you may need to try
      registering the dll. To do that, open a command prompt window and type

      regsvr32 "path\file. dll"

      http://members.iinet.net.au/~allenbrowne/ser-38.html


      --
      Wayne Morgan
      Microsoft Access MVP


      "Kathy" <Kathy.merecat. com> wrote in message
      news:40217ba0$0 $70303$75868355 @news.frii.net. ..[color=blue]
      >
      > Hi All,
      > I have several users who are getting a compile error "Can't find project
      > or library when the code hits
      > Dim cat as ADOX.Catalog
      >
      > In the references dialog box it show the msadox.dll as missing BUT it's
      > in it's folder right where it belongs. I'v tried decompiling the
      > database using the switch to no avail. The database runs fine on my
      > machine. No one had any problems with it yesterday and nothing has
      > changed.
      >
      > I could really use a suggestion!
      > Thanks,
      > Kathy
      >
      >
      > *** Sent via Developersdex http://www.developersdex.com ***
      > Don't just participate in USENET...get rewarded for it![/color]


        Comment

        • Terry Kreft
          #3
          Re: Compile error: Can't find catalog - But the reference isn't missing!

          If the files in place then it probably isn't registered.

          Use regsvr32 to register the dll using the following format

          regsvr32 "C:\Program Files\Common Files\System\ad o\msadox.dll"

          Obvously you may need to change the path to msadox.dll and you may have to
          put the full path to regsvr32.

          Terry


          "Kathy" <Kathy.merecat. com> wrote in message
          news:40217ba0$0 $70303$75868355 @news.frii.net. ..[color=blue]
          >
          > Hi All,
          > I have several users who are getting a compile error "Can't find project
          > or library when the code hits
          > Dim cat as ADOX.Catalog
          >
          > In the references dialog box it show the msadox.dll as missing BUT it's
          > in it's folder right where it belongs. I'v tried decompiling the
          > database using the switch to no avail. The database runs fine on my
          > machine. No one had any problems with it yesterday and nothing has
          > changed.
          >
          > I could really use a suggestion!
          > Thanks,
          > Kathy
          >
          >
          > *** Sent via Developersdex http://www.developersdex.com ***
          > Don't just participate in USENET...get rewarded for it![/color]


            Comment

            Previous template Next
            Working...