I have about 150+ Access '97 (I know..) applications to support, and all of them have a libary.mde add-in that is used for common funcitons.
I'd like to impliment report run logging within my libary.mde add-in by linking within the addin to a table, and then doing basic Insert/Update SQL.
Problem: In VBA in the add-in, CurrentDB() will refer to the front-end application, and not the addin itself.
In VBA in an addin .mde, how do you set a reference, either DAO or ADO, to a table within the addin, and not the calling .mdb?
This works when I link the 'log' table to the front-end .mdb, but I'd rather link to one addin .mde instead of 150+ frontend .mdb's.