Exporting Multiple Objects

[teel73]

I want to cycle thru each object (all tables,forms,queries,macros & modules) in my database and export it to another database keeping the same name for the object. I know how to export 1 object at a time but I can't figure out how to cycle thru the object collections. Does anyone know how I should accomplish this? Thanks in advance.

 

[Trevor G]

You can create a macro to do this using the CopyObject action, then just add more arguments to do the next objects, if you are doing all the objects wouldn't it be easier just to copy the whole database?

 

[teel73]

Thanks Trevor , but the database is secured and I need to create the same database and associate with a different database workgroup.

 

[Trevor G]

Then use the copy object macro, if you then want this done in VBA you can place the macro on a form as button then convert the macro into vba (this is the closest you can get to recording a macro in Access), therefore you can then look at the VBA code and add more copy objects commands.

 

[teel73]

Thanks. I got the transfer database method to work.