Code Library Reference

ClaudiaCastle · February 19th, 2007, 11:29 AM

We have a code library compiled as an mde. Our application connects to this library using the setting RefLibPaths in the registry. This is all working fine. Our problem is if we want to upgrade our code library we have to recompile the application. The application complains "The expression you entered has a function name that Microsoft Access can't find". I've searched the web with no joy - only hints there maybe something hidden like a GUID. Any ideas. We are using MS Access 2002 on XP

mmcdonal · February 20th, 2007, 09:03 AM

When you say that you have to recompile the application, what are you doing? Are you using the original MDB file, making changes, and then recompiling that file? Or are you trying to recompile an MDE? (Can't do that.) What changes are you making?

mmcdonal

ClaudiaCastle · February 20th, 2007, 09:14 AM

Application has a reference to a compiled version of the library. If we wish to update the library we complete the changes and recompile. However, if we just copy across the new mde version of the library to the old version of the library the application with the reference will complain.

mmcdonal · February 20th, 2007, 09:49 AM

It sounds more like an application issue. How do you point the application to the reference library? Is the application Access, or some other?

mmcdonal

ClaudiaCastle · February 20th, 2007, 09:54 AM

The code library is written in MS Access 2002.
The application is written in MS Access 2002. It has this as a reference which is defined through Tools References.
To me it appears as if when you do a code change in the code library a checksum is generated. When the application is compiled against a set of references it remembers this checksum. When the amended library is copied over the checksum differs to the one the application is expecting and it all falls apart.
Any pointers are much appreciated.

mmcdonal · February 20th, 2007, 10:13 AM

That sounds about right since it is a tools reference. What happens when you reselect the tools reference? If that fixes it, I think the checksum is correct. That is most likely internal to Access.

I would suggest searching the registry with the .mde filename and seeing if you can troubleshoot from there.

mmcdonal

ClaudiaCastle · February 20th, 2007, 12:23 PM

I've searched the registry and can't see anything relevant.