Updated the Late Binding page

I've updated the Late Binding in Microsoft Access page on my web site to include conditional compiler constants and directives.  These make it much easier to move between early binding for debugging and VBA Intellisense to late binding which eliminates version and weird messages when the external application doesn't exist on the target system.

Published Sunday, December 02, 2007 1:25 PM by Tony
Filed under:

Comments

# re: Updated the Late Binding page

Conditional compilation can also cause problems that you may want to be aware of. I once had lots of problems trying to get the Multipik form from the Access 2002 Developer's Handbook sample to work in a database with Access 2003. I ended up having to remove the conditional compilation, in order to get it to work.

Try using the /decompile switch with code that includes conditional compilation, but don't be surprised when you get a GPF. Here is a direct quote from Ken Getz, from a private e-mail reply to me:

"If you have conditional compile flags in your code, the /decompile option simply doesn't work. Nice feature, eh?"

Thursday, December 06, 2007 2:54 PM by Tom Wickerath

Leave a Comment

(required) 
(required) 
(optional)
(required)