By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,481 Members | 1,213 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,481 IT Pros & Developers. It's quick & easy.

Using code to copy forms/macros etc

P: n/a
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??
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
nezzler wrote:
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??


Use the TransferDatabase method of the DoCmd object.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.