Protecting Data

M

Mary/Phil Stewart

I have a Access 2K database that I use on once computer. I want to make some
changes to code, macro's, switchboards, forms and reports. I prefer doing
this on my home computer and then transferring it back to the working
machine.
While I am working on the changes the data in the tables may have additions,
deletes and other changes.
Is there a way that I can make my updates as planned but not alter the data
in the tables on the working machine?
Thanking all who can help in advance.
Phil
 
A

Averil Pretty

Hi Phil,

Use the Database Splitter (Tools > Database Utilities >
Database Splitter).This seperates your database into a
front end and a backend. The backend is your tables with
the data and the frontend is your forms, queries etc.

Regards,
Averil
 
V

Van T. Dinh

Split your database to Front-End and Back-End. The Back-End only contains
the Tables. The Front-End contains all other Access objects and linked
Tables from the Back-End. This way, you can modify the Front-End (at home)
and replace the Front-End at work when you are ready without affecting the
data.

See Access Help on splitting a database.
 
Top