Backing Up a Database

R

Ron A.

I have a database that is stored on a shared drive so that several people can
add data to it. What is the best way to create a backup? Also, I have 2
Inspectors adding data from different shops, is there a way to merge the data
into one data base?
 
V

Van T. Dinh

Is the Back-End file on the file server? You can use a the Scheduled Tasks
in Windows OS to make a copy of the Back-End after hours.

For the second question, do you have any network connection to the "other"
shops?

Check Access Help / your Access books on "replication".
 
A

Albert D.Kallal

Ron A. said:
I have a database that is stored on a shared drive so that several people
can
add data to it.
Click to expand...

When you got a minute, read the following article of mine that explains the
correct way to run ms-access with more then one user. This article is a easy
read, and one that you might also share with your IT people.

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
What is the best way to create a backup?
Click to expand...

You on a regular bases should do a compact and repair, and then simply
ensure that the mdb file is included in your DAILY backup set. Again, you
MUST back up the data file on a daily bases. To do other wise is to risk
loosing your data file.
Also, I have 2
Inspectors adding data from different shops, is there a way to merge the
data
into one data base?
Click to expand...

You can either have those remote shops have a live connection to the actual
data, and thus you don't have a "merge" problem at the end of the days work.
And, you need to consider how you will support, and update these users. I
talk about using remote connections, and "far" away users with ms-access
here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
 
Top