Is there a way to add forms and modules to an Access database programmatically from VBscript?

[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.

[JJ]

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.

[GS]

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.

Have a look at the VBA component. It allows full automation of Access, forms,
and controls.