copy all modules

[Guest]

is there any way to copy all the modules of the current database to another
database? modules such as tables, queries, forms, reports, etc. with all
their functions and procedures.

thank you.

 

[Brian Bastl]

Yes, create a new blank database. Then on the Menu bar, go to File |
External Data | Import. Locate the database from which you'd like to import
everything. A window will open that shows all of the objects in your db. On
each individual tab, Click "Select All". Once everything is selected, click
OK. That's it.

HTH,
Brian

 

[tina]

open the database you want to copy the objects *to*, and from the menu bar
click on File | Get External Data | Import. choose the *from* database in
the dialog, and choose Select All on each tab of the Import Wizard. if you
want to transfer Import Specifications and/or custom Menus and Toolbars
also, then click the Options button on the Tables tab.

hth

 

[Guest]

Thanks for the reply, but what i meant was to automate this process by using
functions in visual basic to do this process or any other way.

any replies is appreciated.

thank you