Greetings all. This is my first post here. I was unable to find an answer in previous posts. I basically do not know anything about DOS, but I have managed, by extensive trial and error, to create a batch file, Install.bat, to copy an Access database from a share drive to my local desktop as follows:
COPY /Y \\106.102.5.44\fttpva_shared\FTTP.adp "c:\documents and settings\all users\desktop" /v
The only way I could get it to work is by putting "" around the destination. It works fine, and I can immediately open the file by clicking on it once it is intalled. I also have another batch file, decompile.bat, to decompile and open FTTP.adp as follows:
c:windows /decompile c:\documents and settings\all users\
start/max fttp.adp
If the FTTP.adp file is installed on my desktop by opening the share drive and right clicking and pasting it on my desktop decompile.bat works fine and opens the file. When FTTP.adp is installed via my Install.bat, however, I get the error message:
"Windows can not find 'fttp.adp'. Make sure you typed the name correctly then try again, blah, blah, blah."
If I go into explorer the file is right there as it should be in c:\documents and settings\all users\desktop, so why can't windows find it? Am I missing something? I am using XP service pack 2, but some of my users have older computers. My goal is to create a simple batch file that will overwrite their local copy of our database frontend if they already have it, or install it if they do not, then open it. I want to get away from having to email it out everytime I have to make an update to it. It seems like I am missing something so simple. Any ideas? Thank you in advance.