I have a schema modelled in DeZign for Databases which can generate a new Access database, however there does not appear to be any support for storing VBA classes & modules in the model.
When the database is generated from the model I have to open the new database and manually import the VBA classes & modules; there are not too many but it's a bit of a pain given the automatic creation of the rest of the database.
Is there a way to import multiple modules/classes from a single file? Doing so would at least speed up the process even if I still have to perform a manual import. Alternatively does anyone know of an automated way to perform the insert?
I tried concatenating the files generated by Access by doing an export of the code but when I imported it again Access did not parse the file correctly.