Solved

Batch file won't work

Posted on 2011-03-25
11
593 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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 21

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
 

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 21

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

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…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
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 …

735 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