Hi group,

My problem is that when running a routine in MS Access I am getting an error that says that the library is not found. 



The statement command being used is LEFT$.  This totally is a mystry to me.  This application was running fine and now I get this
error message.  It only happens on one PC which of course is the user's PC that needs the application.  When this application is run
on the backup PC the application runs without any errors.  Now I have had this happen before and just can't remember what I did to
solve the problem.  Any ideas are welcomed?   



Can anyone tell me what library LEFT$ command is located in? thanks



That is all for now... 

Mike McCrossin

try LEFT without the "$" for Access 2K



Just a thought.



Walt 

Check your References to see if you have Microsoft Office 8.0 Object 

Library, Microsoft DAO 3.51 Object Library, and Visual Basic for Applicatio

n check off in your list.



Remember: To View References List, open any form and click on the code 

viewer button to view the DAO scripts.  Click on Tools then References to 

see the list of library that is loaded for that particular database.





>>> "Mike McCrossin" <mike_mccrossin@h...> 08/09 12:15 PM >>>





Hi group,

My problem is that when running a routine in MS Access I am getting an 

error that says that the library is not found.



The statement command being used is LEFT$.  This totally is a mystry to 

me.  This application was running fine and now I get this error message.  

It only happens on one PC which of course is the user's PC that needs the

application.  When this application is run on the backup PC the application

 runs without any errors.  Now I have had this happen before and just 

can't remember what I did to solve the problem.  Any ideas are welcomed? 





Can anyone tell me what library LEFT$ command is located in? thanks



That is all for now...

Mike McCrossin

---

It's not the left$ function itself thats the problem. For unknown 

reasons (to me anyway) Access picks on the string manipulation functions 

if you have any problems with external code references. To fix the 

problem:



1) Open the DB on the users PC

2) Open up any VBA Code module.

3) Choose 'References' from the 'Tools' menu.

4) One of the ticked boxes should have the word 'MISSING' next to it.

5) Highlight the missing link - down near the bottom of the window 

you'll see the file and path of the library file Accesscannot find.

6) Close the DB and replace the missing file

6) This file must be available on your developmnt machine, so you should 

be able to copy it across to the users PC

7) Ropen the DB and check that the missing reference is fixed.

8 Compile and save your code and test that it works!



-BDS

-----Original Message-----

From:	Mike McCrossin [SMTP:mike_mccrossin@h...]

Sent:	09 August 2001 18:15

To:	Access

Subject:	[access] Lost the Library error







Hi group,

My problem is that when running a routine in MS Access I am getting an 

error that says that the library is not found.



The statement command being used is LEFT$.  This totally is a mystry to 

me.  This application was running fine and now I get this error message. 

 It only happens on one PC which of course is the user's PC that needs 

the application.  When this application is run on the backup PC the 

application runs without any errors.  Now I have had this happen before 

and just can't remember what I did to solve the problem.  Any ideas are 

welcomed?



Can anyone tell me what library LEFT$ command is located in? thanks



That is all for now...

Mike McCrossin

Hi Mike,



Check to see whether you have a valid link to Utility.mda data. Also check 

if you can see any other library names beginnning with MISSING:libraryname.





JohnF



>>> mike_mccrossin@h... 10/08/2001 3:15:26 >>>





Hi group,

My problem is that when running a routine in MS Access I am getting an 

error that says that the library is not found.



The statement command being used is LEFT$.  This totally is a mystry to 

me.  This application was running fine and now I get this error message.  

It only happens on one PC which of course is the user's PC that needs the 

application.  When this application is run on the backup PC the application

 runs without any errors.  Now I have had this happen before and just 

can't remember what I did to solve the problem.  Any ideas are welcomed?  





Can anyone tell me what library LEFT$ command is located in? thanks



That is all for now...

Mike McCrossin

So what do I do if i don't have a link to utility.mda data?

that is all for now...MikeMc

>From: John Fejsa

>Reply-To: "Access"

>To: "Access"

>Subject: [access] Re: Lost the Library error

>Date: Mon, 13 Aug 2001 08:55:38 +1000

>

>Hi Mike,

>

>Check to see whether you have a valid link to Utility.mda data. Also 

check if you can see any other library names beginnning with 

MISSING:libraryname.

>

>JohnF

Hi Mike,

If you don't have a valid link to utility.mda or any other reference you 

just have to relink it. 



To relink or add reference to required library:

Open Access

Click Forms tab

Click Code button or View, Code

In code window click Tools, References

Check if any references begin with MISSING:

If any references begin with MISSING: click Browser button and locate the 

required/missing library.



If you need to add a new reference to your database:

Diselect any selected reference

Click Browser button and locate the new library.



In either case...

Select the new library by double-clicking the name

Click OK to add the library to References



PS: I only mentioned utility.mda because we the library extensively, 

however, your project may not need it. 



PS2:  To easily findout what's missing in your database:



Open any code module and click Compile and Save all modules



If any references have a broken link the compile will tell you what's 

missing and open References dialogue box to show you the missing link.



John



>>> mike_mccrossin@h... 13/08/2001 23:55:00 >>>

So what do I do if i don't have a link to utility.mda data?

that is all for now...MikeMc

>From: John Fejsa

>Reply-To: "Access"

>To: "Access"

>Subject: [access] Re: Lost the Library error

>Date: Mon, 13 Aug 2001 08:55:38 +1000

>

>Hi Mike,

>

>Check to see whether you have a valid link to Utility.mda data. Also

check if you can see any other library names beginnning with

MISSING:libraryname.

>

>JohnF