Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Unanswered: Access 97 Compile Error

    I have a database that works fine on one machine. On another machine it won't run and gives a "Compile Error: Can't find project or library". Normally when this happens I think no problems, just a typical installation of access, go into set up and select the whole of access, install and then all works fine. But not in this case, and it is not just limited to one machine, its lots i can't get it to run on.

    The error is thrown up because i have used the format command

    format(100,"0")

    and also the mid or right functions.

    Any ideas which library is missing and how i install it ?

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Levin. There is a reference missing. Go to the Modules tab. Either open New or an existing module. Go to Tools > References and see if any items are marked "MISSING". If so uncheck those items. I think you need to make sure that a reference to Microsoft DAO 3.5 object library is checked.



    David

  3. #3
    Join Date
    Nov 2002
    Posts
    2
    Originally posted by DJN
    Levin. There is a reference missing. Go to the Modules tab. Either open New or an existing module. Go to Tools > References and see if any items are marked "MISSING". If so uncheck those items. I think you need to make sure that a reference to Microsoft DAO 3.5 object library is checked.



    David
    Thanks David, that has sorted the problem

Posting Permissions

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