Protecting Data

  • Thread starter Thread starter Mary/Phil Stewart
  • Start date Start date
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
 
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
 
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.
 
Back
Top