Create Batch File To Copy Database

[ADraughn]

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\Spindle_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

 

[David Parkes]

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

 

[ADraughn]

How do I do that?

 

[Pegasus \(MVP\)]

How do I do that?

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!