DB in Access

[sharon]

I want to know, How can I separate the DB from the progran I wrote - meaning:
to Update the program without changing the data which are already exist in
the DB.

 

[Rick B]

You should split your database.

The 'back end' database will contain all your tables and date. The 'front
end' will contain the forms, queries, reports, and code. This database will
be linked to the back end tables.

Each user would have a copy of the front-end on their harddrive and the
back-end would live on a shared drive (network). You could then modify your
master copy of the front end and disrtibute updated copies to all your
users.

Rick B