Backing Up a Database

[Guest]

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?

 

[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".

 

[Albert D.Kallal]

I have a database that is stored on a shared drive so that several people
can
add data to it.

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?

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?

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

 

[Arvin Meyer [MVP]]

For your second question, you may want to look into Access replication:

http://support.microsoft.com/default.aspx?scid=kb;en-us;182886
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access