The normal approach is to split the database into a front-end (containing
the queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). When you have changes to the
front-end, you simply replace it on the other machine(s), without impacting
the data that's there.