Unanswered: Programatically building an Access database
Does anyone know how to programatically push a Basic (VBA) module into Access?
- A utility I wrote that runs raw SQL commands against an (already existing) Access database. It uses ADODB.
- An SQL file that builds all my tables and indexes.
- An SQL file that builds my views and procedures.
- An SQL file that populates the database.
All I'm missing is a way to programatically push my VBA modules and my forms and reports into the database. Right now I have to manually import them or drag-and-drop them from the old version to the new version.