Search notes:

ADOX

ADOX stands for ADO Extensions for DDL and Security.
With ADOX, it possible to create or modify tables, indexes or stored procedure.
Although ADOX can be used with any provider, the Microsoft Jet OLE DB Provider provides full support while the Microsoft SQL Server OLE DB Provider only provides limited support.

Add reference to ADOX in VBA

In a VBA project, a reference for ADOX can be added with
call application.VBE.activeVBProject.references.addFromGuid("{00000600-0000-0010-8000-00AA006D2EA4}", 6,  0)

See also

Create an MS-Access database with PowerShell
Create an MS-Access database with ADOX and VBScript
msadox.dll, located under %CommonProgramFiles%\System\ado
ADOX is a component of Microsoft/Windows Data Access Components

Index