whitespace
Registered User.
- Local time
- Today, 04:37
- Joined
- Aug 30, 2005
- Messages
- 51
I want to create a number of functions that can be called from a number of different databases.
At the moment we store the same functions in a module in each of the databases but when we want to change something we have to update them all which is not only time consuming but it is easy to miss out or forget about databases. We have ended up with lots of versions of the same function spread across a number of databases - if that makes any sense?
In the same way that you have a linked table, is it possible to create a 'linked' module so that all databases can look at one source for functions? Failing that can I create a module that can be called by making it available in the references dialog box (in a similar way that you make the Excel object library available) - I don't know much about that - is it creating a class or something and/or will I need VB6 to do it?
Thanks loads for any help
-Suzy
At the moment we store the same functions in a module in each of the databases but when we want to change something we have to update them all which is not only time consuming but it is easy to miss out or forget about databases. We have ended up with lots of versions of the same function spread across a number of databases - if that makes any sense?
In the same way that you have a linked table, is it possible to create a 'linked' module so that all databases can look at one source for functions? Failing that can I create a module that can be called by making it available in the references dialog box (in a similar way that you make the Excel object library available) - I don't know much about that - is it creating a class or something and/or will I need VB6 to do it?
Thanks loads for any help
-Suzy