Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using a Batchfile to Copy Frontend MDE

Status
Not open for further replies.

Eightball3

Programmer
Nov 23, 2002
138
US
Easyit posted the batch file code below a while back (thanks Easyit!)as a method to copy versioned front-ends to the user's computers. I like this approach but have one problem. I will not have mapped network drives (usually) on the users computers. Is there a way to do this using unc naming within a batch file?

Thanks.
Eightball


echo off
c:
cd\
if not exist C:\FCM\ mkdir C:\FCM\

cd FCM

REM check the version file to see if a newer version exists
REM and copy the front-end if necessary
if not exist "My_versionfile_1A.txt" copy "N:\public_server_folders \MyCompiledFrontEnd.mde" "c:\FCM\ MyCompiledFrontEnd.mde "

REM Now also copy the version file if there is a newr on the server
if not exist "My_versionfile_1A.txt" copy "N:\public_server_folders \MyCompiledFrontEnd.mde" "c:\FCM\ My_versionfile_1A.txt "

REM If the mde file is not present on the local folder, than make a copy
if not exist "c:\FCM\ MyCompiledFrontEnd.mde " copy "N:\public_server_folders \MyCompiledFrontEnd.mde" "c:\FCM\ MyCompiledFrontEnd.mde "

REM Now start up the Database. Make sure the paths are correct:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:\FCM\ MyCompiledFrontEnd.mde " /WRKGRP " N:\public_server_folders\SYS_MyWorkGroupFile.mdw"

exit
 
I use this UNC server path in a batch update routine and it works fine

@cls
@echo off
C:
cd\
cd\MHD
copy \\JchaWin2003\SYS\MHD\NewVersion\*.*
exit
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top