[AccessD] FMS Inc. Sourcebook

Heenan, Lambert Lambert.Heenan at AIG.com
Thu May 3 13:47:03 CDT 2007


I'm on Charlotte's side with this one. :-)

A "library" is a grouping of executable code which can be linked to or have
references set to and the code within becomes available to the client
application. No cutting and pasting involved. The point being that the code
in question is immediately usable by the client once the linkage has been
established. There's also no cherry picking of code routines to make
available. Link to a library and you get it all.

Typically, whenever a library file is modified in any way all the client
applications need to be recompiled as the references/jump tables (or
whatever else is used behind the scenes to define the code entry points)
will have changed.

"<snip>
Access is the ONLY Office application that allows libraries but they are
indeed libraries. 
<snip>"

I can't agree with that statement either. I can put a bunch of code modules
into an Excel file, and in the VBA IDE I can set the project name to
something other than "VBAProject". After I save the Excel file I am then
able to set a reference to it in another Excel and the (public) routines in
the referenced file will be available for use. I have a library.

Lambert



More information about the AccessD mailing list