How can I import reports from 1 mdb to another?

[judyblueyes]

The application development takes place on my personal computer. The application runs on my users computer. He wants a new report added to the application. I can develop the new report on my PC but how do I import it to the application on his PC?

Thanks for any help.

 

[hjgoldstein]

Simply export the report from your mdb to his.

I assume that you are both on a common LAN so you can connect to his PC.

From your application in the database window, highlight the report and click File > Export and then browse to select the name of the mdb on his PC.

Hope this helps.

 

[judyblueyes]

No we are not on a common LAN - we are in no physical way connected. Could I dump my mdb to a CD, take the CD to his PC then export it from there to his mdb?

 

[hjgoldstein]

Yes you could do this, but in a slightly different way.

Copy the mdb onto CD and from his PC, open his copy of the mdb and instead of exporting from yours, import to his.

Use File > Get External Data > import and select your mdb from the CD. You will be prompted with all the tables, reports queries etc. that make up your database, and you can select the report you want to import.

Good Luck!

 

[judyblueyes]

I'll try that - Thanks so much for your help hj

 

[judyblueyes]

Great, I'll try that. Thanks so much for your help hj

 

[ALEKSJAY]

You can open both mdb's in the same computer and drag the report form one to the other

 

[ALEKSJAY]

You can open both mdb's in the same computer and drag the report form one to the other