'Undefined function 'BuildCustomerName' in expression

[Guest]

Hello first time poster

My boss recently moved a DB from one server location to another and now it
is no longer working properly. Please bare with me, I am not very
knowledgable of Access and am primarily an oopl coder. I am using Access 97
in an XP.

The database is comprised of 6 files: Service_Request.mde/mdb,
Common_Code.mda/mdb/mde, and default.mde. Service_Request.mde/mdb both
reference Common_Code.mde and default.mde. Service_Request.mdb/mde reference
default.mde and Common_Code.mde.

Service_Request has a login screen when you first start it up caused (I
assume) by a macro that makes the call: login("frm_requestlist"). A prompt
appears where i can enter a user name and login but when I click ok it
crashes about 1 minute later with the 'Undefined function 'BuildCustomerName'
in expression' error. I can bypass the login with the Shift+F11 shortcut but
all of the forms crash when I double click them.

The function 'BuildCustomerName' is located in Common_Code in the module
'Library'. However, I looked through the code in Service_Request and
Common_Code and except for its definition, I cannot find a call to it
anywhere. Service_Request does make calls to a few other functions in
Common_Code, but I am unable to tell if they are working or not.

I have checked the references for Service_Request with a reference wizard
and as far as I can tell they seem correct. It references both Common_Code
and default in their current locations on the server. However, even if they
were incorrect I cant figure out how to change them with my current resources.

Any help in this matter would be greatly appreciated as would tips on how to
step code cause I havent been able to figure that out either.

 

[Ken Snell [MVP]]

Moving a database from one location to another probably is the source of the
problem. You didn't say which file he/she moved (just a wild guess, but most
likely it was the Common_Code.mda, Common_Code.mdb, or Common_Code.mde
file), but obviously the other files don't know that that one file has been
moved, so they're still looking for the file where it used to be.

Either move the one file back to where it was, or change all the references
/ links to that database to now use its new location.

 

[Guest]

The entire database and folder structure was moved at the same time and
unfortunately going back to the previous server is no longer an option. I
have updated all linked tables as well.

 

[Ken Snell [MVP]]

Guessing again, but the add-in from Common_Code.mda may not be seen any
more. Try adding it back to the databases' add-in list.

 

[Guest]

"Add-inn" ? I am not familiar with the term. Is there a wizard or tool i
need to look at to accomplish that?

Thanks for your help btw.

 

[Ken Snell [MVP]]

A ".mda" file suggests that it is an "add-in" file, meaning that its
functions can be made available to other database files just as if the code
had been included in the original database. This .mda file likely was
created by the person(s) who created the other files?

This link will take you one of many pages on MS' web site about add-ins for
ACCESS:
http://office.microsoft.com/en-us/assistance/HP051889871033.aspx

This link will take you to a search page with some ".mda" info and links
that will take you to other pages.
http://office.microsoft.com/en-us/results.aspx?Scope=TC,HP,HA,RC,FX,ES,EP,DC,XT&Query=mda&App=AC