Apologies if this has been posted, I did search without finding anything.
I've got a legacy database written using Macros that is displaying problems when run in Access 2003. When trying to open forms using certain actions which appear related, but not limited to what's described here:
http://support.microsoft.com/kb/841916
You get the error message: "You don't have the license required to use this ActiveX control"
As far as I can see the solution is basically to rewrite the application, something that is on the cards anyway, if nothing else to get away from Macros because they're a pain to figure out what they do when you've no documentation (cry me a river!)
Now my question is, does Access provide any means to enable you to make bulk changes to existing macros? Or if not bulk changes, can I identify which macros contain the offending code without having to go through them one at a time?
I've got a legacy database written using Macros that is displaying problems when run in Access 2003. When trying to open forms using certain actions which appear related, but not limited to what's described here:
http://support.microsoft.com/kb/841916
You get the error message: "You don't have the license required to use this ActiveX control"
As far as I can see the solution is basically to rewrite the application, something that is on the cards anyway, if nothing else to get away from Macros because they're a pain to figure out what they do when you've no documentation (cry me a river!)
Now my question is, does Access provide any means to enable you to make bulk changes to existing macros? Or if not bulk changes, can I identify which macros contain the offending code without having to go through them one at a time?