How to update a .mdb file without overwriting records?

[marcondes]

I have been working on a client's database and every time I modify a form, a report, or a query I bring the whole .mdb file on a CD to their office and export the modified form or report one by one.
Is there an easier way to do it without overwriting the data entry my client was inputing while I was modifying the database?

Thanks!

 

[dawnd3]

Split the database into a back end (tables) and front end (queries, forms and reports).(2 mdb's) When you make changes, you can just copy the front end mdb over the old one without interfering with the data.

Dawn

http://www.calliopeconsulting.net