Hi, Am.
You're trying to put the cart before the horse. You will have to replace
the original database that you've already published with an updated version
that provides for this feature, or you will have to create and distribute a
utility that alters your already published database, or you are going to
have to skip this feature.
Unless you've already put a public interface on that public variable that's
defined and set in the current database (the one that you've already
published), then other databases and applications won't be able to retrieve
that value.
By public interface, I mean a public getCompanyName( ) function in a
standard module, or a value set in a specific control on a specific form, or
a value stored in a table, or a custom database property, or *something*
that can be an output value from the current database. Any of these
examples would have to be defined in the current database, which can then be
controlled programmatically from the Add-in database.
If you haven't already provided this functionality in the current database
and you really, really need it, then you'll have to update the database file
and then redistribute it to your customers. Either that or you'll have to
create a utility that adds one of the examples above of the functionality
you need to retrieve the global variable, and then distribute that utility
(with instructions) to your customers to alter your already published
database.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
