Saving forms for transfer

[realnine]

I completed a search for my question with no answers. I have searched Access help and still no answeres.

Here is my problem. I am helping my son, who is 400 miles away, with Access application for a small business. He sends me the most current mdb file for me to work on. In the mean time he is entering data. If I edit any thing and send it back as a MDB file, he loses all the data he has entered.

When I edit a form, report or querry is there a way to save the querry or form as a stand alone file. Then I would email it to him and he could import it without cahnging any other part o the MDB.

Thanks for helping.

 

[dcx693]

The easiest way is to split the database into a front end and a back end piece. The front end would consist of the objects other than tables (such as queries, forms, reports, projects, macros and modules). The backend would consist of only the tables that feed into the database. Then you could just send your son a new front end piece each time. You wouldn't be touching any data. Search the Access help for splitting database. The command itself is at Tools, Database Utilities, Database Splitter (in Access 2002). At worst, when your son receives a new front end, he'd need to run the linked table manager to tell the front end where the back end files are located - and that's only if you and he store it in a different path on your respective PCs.

The alternatives involve importing/exporting of objects and that's a pain.

 

[realnine]

Thanks dcx693,
Your suggestion is what I need. I was looking in th wrong places.

RealNine