Backup Button on Desktop

  • Thread starter Thread starter HeatherM
  • Start date Start date
H

HeatherM

Is it possible to have a button on my desktop that will
copy the back end table files from the server onto a file
on my hard disk?
i.e. copy file F:\Database\Tabledata.mdb to
C:\Backup\data.mdb
Not that I don't trust IT to backup my tables but belt &
braces wont hurt will it? As a subsidiary backup I don't
mind if it continually overwrites the same file.

I'm using Windows98 and Access97
 
Hi,

Create a DOS Batch file (basically a one liner).

copy F:\Database\Tabledata.mdb C:\Backup\data.mdb

Put the batch file on your desktop or something, and run
it whenever you want.

Regards,
Eric
 
-----Original Message-----
Is it possible to have a button on my desktop that will
copy the back end table files from the server onto a file
on my hard disk?
i.e. copy file F:\Database\Tabledata.mdb to
C:\Backup\data.mdb
Not that I don't trust IT to backup my tables but belt &
braces wont hurt will it? As a subsidiary backup I don't
mind if it continually overwrites the same file.

I'm using Windows98 and Access97
.
Click to expand...

Don't use the Copy command. Use Xcopy instead. It has a
wealth of command line parameters that will allow
overwriting only newer files, not prompting for
overwrites, copying subfolders, and lots more.

I use a series of XCopy command to back up everyting to my
server and even keep my notebook current with my
workstation. Here is an example:

XCOPY "D:\Visual Basic Projects\*.*" "J:\Visual Basic
Projects\" /C /D /F /H /I /K /R /S /Y

Don't forget to use quotes around the paths if there are
spaces in them. I always use them just to be sure.

Open a command prompt and type Xcopy /? to see a list of
all the paramaters you can use and what they mean.

Once you create the batch file, just put a shortcut on
your desktop.
 
Back
Top