How to Copy updated object design from test to live database

[Guest]

I have a working database that needed some upgrading & new reports, so I took
a copy of the DB to develop the changes. Meanwhile the live DB is still in
use so the data is changing. How do I copy the chnged objects (tables,
queries, reports) back to the live DB without corrupting the data? I've tried
the import/export as per online Help, but the imported objects simply add to
the object list if there already exists an object by the same name, which in
many cases there will be if i've just modified the design of that object.
Thanks, Paul

 

[Guest]

BTW- I enquired of MS "Support" & once they dertermined this is not a
"break/fix" issue, they didn't car two hoots! Pathetic! I hope there is
someone ou there who can help with this. Thanks in advance, Paul

 

[Rick Brandt]

I have a working database that needed some upgrading & new reports,
so I took a copy of the DB to develop the changes. Meanwhile the live
DB is still in use so the data is changing. How do I copy the chnged
objects (tables, queries, reports) back to the live DB without
corrupting the data? I've tried the import/export as per online Help,
but the imported objects simply add to the object list if there
already exists an object by the same name, which in many cases there
will be if i've just modified the design of that object. Thanks, Paul

Anyone who designs Access apps seriously always uses a split app. One file with
just tables and another linked to the first with everything else. That way,
non-table design changes is simply a matter of replacing one file with another
and re-establishing the links to the tables.

As for the import...if you want to import a new version of a form then delete or
rename the original before the import.