Tech Support > Microsoft Windows > Create Batch File To Copy Database
Create Batch File To Copy Database
Posted by ADraughn@mazakcorp.com on February 21st, 2006


Greetings All.
Windows xp

I am attempting to create a batch file that will copy my database. I
need the front end and the tables copied to a server for a regional
office.

This is what I did, maybe someone can tell me why it didn't work:

(I'll use the copy of the tables database for an example)

1. I opened Notepad and entered this line (as one line):

Copy
\\Servicesrv1\Optimum\Spindle\Spindle_DataBase\Spi ndle_DB_Tables.mdb
\\Hartford\Shared\Spindle data base /Y

2. I saved the file as Filename.bat

3. When I run it, I can see the screen pop up and close but nothing
happens.

Questions:

1. Does the problem have anything to do with the regional office's file
containing spaces?

2. Can I copy my tables and my front end with one batch file?

Thanks in advance to all,

-doodle

Posted by David Parkes on February 21st, 2006


Put a pause in the next line and then run it. You will see what is going
wrong better that way


Posted by ADraughn@mazakcorp.com on February 21st, 2006


How do I do that?

Posted by Pegasus \(MVP\) on February 21st, 2006



<ADraughn@mazakcorp.com> wrote in message
news:1140540049.134367.298870@z14g2000cwz.googlegr oups.com...
By adding this line:

pause

You should open a Command Prompt (Start / Run / cmd {OK})
and type

help /?

to see the wealth of commands available to you!




Similar Posts