Backup

[Guest]

What is the best way of backing up an Access database ?
I have an .MDB and .mde file.
SHould the database be backed up from file-Backup database or using OS
commands ?

Any help appreciated.

Regards,
Pawan

 

[Guest]

Access 2003 includes a built-in command for creating backups:

File > Back Up Database...


Use Windows Explorer with all previous versions of Access. Make your backups
with the database closed (ie. no locking database file present).


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[g24bcf7y]

What is the best way of backing up an Access database ?
I have an .MDB and .mde file.
SHould the database be backed up from file-Backup database or using OS
commands ?

Any help appreciated.

Regards,
Pawan

 

[Guest]

Is there an automated way of scheduling the backups ?

Pawan

 

[Guest]

Yes. Do a Google Advanced Groups search

http://groups-beta.google.com/advanced_search

with the search words: backup database schedule Windows. You will find lots
of hits, for example:

http://groups.google.com/groups?as_...05&as_maxd=21&as_maxm=3&as_maxy=2006&safe=off

If you can afford the software, a nice alternative is to use Total Visual
Agent by FMS:
http://www.fmsinc.com/products/Agent/index.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

However, I want to provide the user of the database with the option to back
up the database when he wants. I would like to use the new command (as of
Access 2002/3): Back Up Database ... (this is found on the File menu and the
Tools --> Database Utilities menu). This command is available only when you
have a database open and does not allow you to specify which database you
would like to back up (it assumes the currently open database), then you are
allowed to specify the location and file name. This command works fine from
the menu but how do I schedule it ?

 

[Guest]

Hi Pawan,

I can tell you that there is no such menu item in Access 2002. This is a new
feature available only to Access 2003. Since I am working mostly with Access
2002, I cannot tell you how to proceed. You might want to try the following
KB article:

How to Compact Databases At a Scheduled Time
http://support.microsoft.com/kb/209979/en-us

Here is a lead for accomplishing this from a different database:

http://www.access.qbuilt.com/html/custom_login.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Ron2005]

But that backup will backup the mdb you are in (most probably the FE)
and NOT the mdb where the tables are (the BE).

See my comments in your other posting.

 

[Guest]

Hi Ron,

I don't know if you were answering me or Pawan, but come to think of it,
you're right assuming 1) this is a multiuser database and/or 2) he has split
the database (as he most definatly should for a multiuser database--optional
for a single user database).

Do you have a link to your other posting? I can probably find it by
searching, but a link would be easier for me and anyone else who is
interested.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Ron2005]

Here is what I posted:

Besides that, what the menu backup does is backup the application that
you are running NOT the BE tables that contain the data.

We have accomplished the backup process in two different ways.


1) create a BAT file to do the copies of the BE mdb file and use
windows scheduling to schedule the task


2) We created a stand alone mdb with an auto exec that essentially does

the same copy scenario, however it reads a linked backup control table
that tells it what / where the files are to be backedup and where to
put them and when to do this. Then we used windows scheduling to call
this app every two hours during the working day to perform whatever
backups the control table says to perform. It works great. We added it

for a heavily used mdb that it turns out the network backup only
backedup every 2 weeks or so. That was too much to redo a second time
(after we did it that one time).


Ron


and possibly this is the link:

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/d4c3c495d982374d/?hl=en#