Post by Dan Campbell
Is there a tool or a vbscript method to automate the generate of an Access
database, INCLUDING the forms and modules?
I know how to create the tables progrmmatically, of course. But I'd like
to be able to generate everything, via script.
A free script or a commercial tool are both ok. Whatever works.
I think it can be done using Windows Scripting Host's VBScript (not to be
confused with MS-Office's VBScript). i.e. create projects, databases, forms,
and modules. All from scratch.
Although it would be better to use WSH-VBScript mainly as a "kick starter".
i.e. to create the module which contains the main automation script, then
continue the automation from the Office-VBScript context. Because in the VBA
context, many of the external objects are preloaded, and it also includes
several macros and additional functions.
MS-Office came with an offline help which also contain guides and references
for its VBScript. If it didn't get installed when the application is
installed, update the application setup to install it.