The following is all in Access 97:
I have a library of functions set up in an MDA file. The MDA is located on a network share that is accessible by several machines. I changed one variable type in a function in the MDA from Integer to Long, due to an overflow error that was occuring. I have several Access databases that use this library. Some of these still get the overflow error, as if they are still seeing the variable as an Integer rather than a Long. If I open references in the databases, and re-ref the MDA, the databases macros will run fine.
My problem is that these remote databases are copied from a baseline version before being used to run on the data. If I change the baseline database file (re-ref the MDA file) and then copy it to a working location, the change does not take effect. As soon as I open this new copy, and re-ref however, the problem goes away.
Does anyone know how to get the change to stick? Where is the ref to the old version of the MDA coming from? (side note: If you select debug when the error occurs, it takes you to the correct mda code, it just isn't executing this code)
Any help would be great. Thanks.
I have a library of functions set up in an MDA file. The MDA is located on a network share that is accessible by several machines. I changed one variable type in a function in the MDA from Integer to Long, due to an overflow error that was occuring. I have several Access databases that use this library. Some of these still get the overflow error, as if they are still seeing the variable as an Integer rather than a Long. If I open references in the databases, and re-ref the MDA, the databases macros will run fine.
My problem is that these remote databases are copied from a baseline version before being used to run on the data. If I change the baseline database file (re-ref the MDA file) and then copy it to a working location, the change does not take effect. As soon as I open this new copy, and re-ref however, the problem goes away.
Does anyone know how to get the change to stick? Where is the ref to the old version of the MDA coming from? (side note: If you select debug when the error occurs, it takes you to the correct mda code, it just isn't executing this code)
Any help would be great. Thanks.
