Solved

Can't find project or library. How do I fix this?

Posted on 2004-10-15
5
266 Views
Last Modified: 2010-08-05
Hello all,

I'm trying to use the MDB database made on one PC at another PC. Access is 97 on both PCs. However, when the script reaches the lines:

Private Sub ProdRunCombo_Change()
    If Trim(Left(Me.ProdRunCombo, 1)) = 0 Then
        Me.StartField.Enabled = False

an error 'Can't find project or library' appears, and the word 'Left' is highlighted. I assume that the 'Left()' function is not defined in target Access for some reason - I can't view Help on it, although it is listed in Objects list there.

How can this be fixed? Re-link some reference?

P.S. When I compile an MDE at my PC, everything works OK there - but I need an MDB to work.
0
Comment
Question by:Yaroslav_Buzko
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 3

Accepted Solution

by:
StuartSanders earned 43 total points
ID: 12317431
In a code window, got to tools > references.

Note down the exact versions that appear checked on both your machine and at the other machine.  Chances are one of them is slightly different.  Maybe Microsoft DAO 3.5 and 3.51.

Also make sure that both machines are running Access/Office with the same service pack level.  Its been a while but I think SR2b was the last for office 97.

if that doesn't give you any satisfaction, please give me the list of references that are selected.

Stuart
0
 
LVL 44

Assisted Solution

by:Arthur_Wood
Arthur_Wood earned 41 total points
ID: 12317867
in addition to what StuartSanders has said, also check, under Tools/References for aANY reference marked as MISSING.

If there are 'Missing' References, make a note of which one(s), then UNCHECK the MISSING reference, and click on the OK button.  Then re-open Tools/References and re-select the previous MISSING reference - the list is alphabeticval, and you will need to scrool down the list to re-locate the previously MISSING reference.  Select it (so the Check box is CHECKED) then click the OK button again.  That should resolve the problem.

AW
0
 
LVL 50

Assisted Solution

by:Steve Bink
Steve Bink earned 41 total points
ID: 12322660
The library you are having difficulty with is the standard "Visual Basic for Applications" library.  In my installation with Office 2002/XP, the filename you will be looking for is VBE6.DLL, and is located by default in "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6".  Since you are using Access 97, your version may be different...You will have to look at the References to get the actual filename.

You can search your drive for the file and use REGSVR32 to register it again, if necessary.  Otherwise, just copy the file from your working PC to the non-working PC, then use the Reference dialog to point Access to the right place.

As a side-question, did you install 2 different versions of Access on the 'bad' PC?  Or even upgrade from a previous version of Access on that computer?
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question