How to add VBA code programatically to an MDB?

[Lee Gillie]

I figured out I can create a VBA function, and refer to it in the SQL
to display an integer formatted as binary.

The question is finding the right technology to create the table, on
the fly for this. The production system creates MDB key files for a
complex task. I want to provide a convenience for those viewing the
data, ad-hoc, using MS Access.

My thought is to add VBA code to the MDB, a function taking an integer
as input, and a string as output to do the formatting. To create
QUERIES on the tables which utilize the formatting function. I can do
this interactively, but the question is can this sort of thing be done
programmatically? (i.e. especially adding VBA code) I am currently
using ADOX to create the MDB, but will change APIs if I need to.

Thanks for any thoughts on the subject.

Best regards - Lee Gillie