Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 19th, 2007, 11:29 AM
Registered User
 
Join Date: Feb 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Code Library Reference

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

 
Old February 20th, 2007, 09:03 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old February 20th, 2007, 09:14 AM
Registered User
 
Join Date: Feb 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

 
Old February 20th, 2007, 09:49 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old February 20th, 2007, 09:54 AM
Registered User
 
Join Date: Feb 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default


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.

 
Old February 20th, 2007, 10:13 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old February 20th, 2007, 12:23 PM
Registered User
 
Join Date: Feb 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Standard Library Reference resource markcholland BOOK: Professional C++ 0 March 17th, 2006 02:31 PM
Include Library Reference at RunTime Stoney Excel VBA 4 January 14th, 2005 03:40 AM
Where is Code for Java XML Programmer's Reference! yueliu Wrox Book Feedback 6 December 6th, 2004 11:28 AM
How to reference Public Variable in Code Gino Liu Access VBA 2 June 18th, 2003 01:42 PM
Code Library broch VS.NET 2002/2003 0 June 4th, 2003 03:01 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.