To open my database i run code through a cmd prompt that copies the front end of the database onto my local machine using the code below.
copy "\\retail\DB.mdb" %Temp%\DB.mdb /y
start "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" %Temp%\DB.mdb
Exit
Before the code copies the front end i want to check if the database is under maintenance, Idealy by checking if a txt file exists somewhere on my network. If the text file exists, Great run the code above. If the text file is missing, Provide a message saying that the database is under maintenance.
I can do this in code in the database, but would really want to do it in the command prompt above.
Is this easy to do ?
Thanks in advance.
copy "\\retail\DB.mdb" %Temp%\DB.mdb /y
start "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" %Temp%\DB.mdb
Exit
Before the code copies the front end i want to check if the database is under maintenance, Idealy by checking if a txt file exists somewhere on my network. If the text file exists, Great run the code above. If the text file is missing, Provide a message saying that the database is under maintenance.
I can do this in code in the database, but would really want to do it in the command prompt above.
Is this easy to do ?
Thanks in advance.