Solved

Batch file won't work

Posted on 2011-03-25
11
590 Views
Last Modified: 2012-05-11
I created a batch file to copy and past an access database from the server to the clients computers, but it does not do the job. Can someone tell me what is wrong with my batch file. Thanks!
The batch file is as follow:

@echo off
rem This batch file installs the Membership front-end (Access .MDB file) on the user's PC.
rem It runs from the server where the front-end resides.

C:
xcopy "\\server_name\directory_from_the server\Membership.mdb" "C:\Membership\" /y /i
exit
0
Comment
Question by:SambaCor
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 11

Expert Comment

by:nordtorp
ID: 35218662
try to use this instead:

C:
net use x: "\\server_name\directory_from_the server\"
xcopy "X:\Membership.mdb" "C:\Membership\" /y /i
exit

Open in new window

0
 

Author Comment

by:SambaCor
ID: 35218915
I tried your suggestion nordtorp, but that didn't do it either.
I forgut to mention that the file to be copied reside on a windows 2008 server. The client machines are running xp pro.
Thanks!
0
 
LVL 11

Expert Comment

by:sighar
ID: 35218987
An error message would certainly help us figure out what the problem is.

Do you have access to \\servername\sharename from the XPs? Can the user you logged in as access it and copy manually?

Also, I've had problems with copying databases when they're live, i.e. in use. Is that the case here?
0
 
LVL 11

Expert Comment

by:nordtorp
ID: 35219010
Try to turn on File and printer sharing on the server. You find it in Network and Sharing Center
0
 
LVL 20

Accepted Solution

by:
CompProbSolv earned 500 total points
ID: 35219014
Can you try running the xcopy line at a workstation from a command prompt and report what the result (did it copy?  what messages did you receive) is here?
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:SambaCor
ID: 35219051
I don't get any error message.
Yes I have access to \\servername\sharename from the XPs.
Yes, I can copy the database and past it manually, no problem.
The database is not open.

I also hear of robocopy, would that be easier to use in my scenario? I have never use it before.
0
 
LVL 20

Expert Comment

by:CompProbSolv
ID: 35219088
You are saying that it runs fine if you just run the xcopy command, but not if you run the batch file, everything else being the same?

How are you running the batch file?  (on which computer, from run or cmd, or?)
0
 
LVL 11

Expert Comment

by:nordtorp
ID: 35219125
The robocopy command would be almost the same:

robocopy \\source \\destination
0
 

Author Comment

by:SambaCor
ID: 35219229
When I run xcopy from the command prompt I get the error: file not found.
But when I right click on the file and copy (from the shared drive), I am able to past it on the local machine.
I am running the batch file on the xp machine by just double clicking it. The batch file is a short cut on the desktop. But it is located on the shared folder on the server.
0
 

Author Comment

by:SambaCor
ID: 35219308
Sorry guys xcopy from command promt works fine, I didn't type it correctly.
The batch file is actually working now without the net use syntax.
I would like to give the points to CompProbSolv. And thak you to nordtorp for helping.
0
 

Author Closing Comment

by:SambaCor
ID: 35219318
It worked when I run it from the command prompt and I went from there.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now