Using code to copy forms/macros etc

I am currently attempting to write some code which will connect to a
seperate db, identify all the objects (table, queries, forms, macros,
modules etc) and create a clone of these objects in the host db.

This is effectively a programmatic method of the 'Import'
functionality within Access.

I have managed to list the objects, but cannot find a way to
copy/clone them into the new databse.

Any ideas anyone??

re: Using code to copy forms/macros etc

nezzler wrote:[color=blue]
> I am currently attempting to write some code which will connect to a
> seperate db, identify all the objects (table, queries, forms, macros,
> modules etc) and create a clone of these objects in the host db.
>
> This is effectively a programmatic method of the 'Import'
> functionality within Access.
>
> I have managed to list the objects, but cannot find a way to
> copy/clone them into the new databse.
>
> Any ideas anyone??[/color]

Use the TransferDatabase method of the DoCmd object.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)