Import multiple forms, queries from another database

[shmoussa]

Here is the story: I have created a database that will be used between
myself and another person.

My work: I manage and create/update queries, forms, vba code, macros,
modules and reports in this database.
My partner: Manages and updates the sole table in the database, using
the forms that I create.

Anytime I make changes to my work, I would like a simple way to apply
those changes to my partner's copy of the database. I don't want to
replace the actual table in the though, as their copy of the database
would have the most updated information.

So, essentially, I just want to be able to import everything from one
database file into another, except for the table- with the push of a
button on my form. Any ideas?

Thanks.

 

[Douglas J. Steele]

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relations). Each of you should have your own copy of the
front-end. Once you're happy with your changes, simply replace his copy of
the front-end.