Solved

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

Posted on 2004-10-15
5
268 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 51

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

689 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