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.

link|improve this question
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.