Copying Objects to another database

[CEV]

I am wondering how I can copy a query or a report from one Access database
to another. I have a development database that I work on and would like to
copy items over to the database that the endusers use as I get them done.

Thanks,

Chad

 

[Jeff Boyce]

Chad

Push or pull.

Open the "from" database, highlight the object, select File | Export, select
the "to" database and export the object.

or

Open the "to" database, select File | Get External Data | Import... and
identify the "from" database and objects.

The latter makes it easier to get several objects simultaneously.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff L]

One of three ways:

Open the development db, select what you want to transfer to the other
DB and click File, Export. Navigate to the other database.

OR

Open the end user db and click File, Get External Data, Import.
Navigate to the development DB, double click it, select the item(s) you
want to import, click OK.

OR

Copy and paste

Hope that helps!

 

[CEV]

Thank You very much. Easier than I thought.

Thanks,

Chad

 

[aaron.kempf]

I would reccomend using SQL Server Management Studio; right-click
GENERATE SCRIPTS.

Access Data Projects made MDB obsolete almost a decade ago!

-Aaron