I have an application which needs to be extended regularly but in a uniform manner as new user requests for functioanlity come alon.

I have a load of functions which are used and extended regularly, and are sim;ly db queries displayed in a grid. It has a stable front end which will not change.

Would it be intelligent to develop an Active X Dll with the functions for doing the db querying, so that I could simply update the dll, rather than the executable every time I needed to extend the project with more functionality.

The appropriate functions are called as the result of a choice in a database ( a user clicks a cell, and the id of the row of the cell is used to call a funtion), so I can always number them to be in sync with the database, and call them from the dll with a number parameter to identify which function I am looking for - i.e. using a case statement as the opening funciton on accessing the dll to determine which function to call.


Does this sound like overkill or sensible?