From: shmoussa on
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.
From: Douglas J. Steele on
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.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"shmoussa" <shmoussa(a)gmail.com> wrote in message
news:71878d82-836f-4170-ac3e-b68438043824(a)b2g2000yqi.googlegroups.com...
> 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.