macro to import objects from another ADP file? 1

[psimon88]

Hello

I have administrative rights over an ACCESS 2003 ADP file. It's a backup of PROD data. I report off PROD data but have to manually import the objects into PROD each time to run the reports. I don't have the ability to permanently save objects on the server.

Is it possible for a macro to 'get external data' from another ADP. I'd like it to pull the views/queries from my BACKUP to PROD.

Thank you in advance.

ps

 

[mp9]

Is the "TransferDatabase" macro action of any use to you?

http://www22.brinkster.com/accessory/

 

[psimon88]

Maybe I missed it, but the arguments there let you specify which objects you want to import?

 

[mp9]

I believe so, via Object Type and Source parameters.

http://www22.brinkster.com/accessory/