Windows 10: Batch file question

I have a MS Access database which uses SQL Server as a backend. I want multiple people to use the database so for ease of distribution I created batch files the go out to a folder and copy the file to a temp folder. That way they always have the latest version if I make changes to the front end. The master file lives in a shared OneDrive folder. The issue I have is that of my users 1 has his OneDrive on his D drive while others have it on their C drive. What I would like is for the batch file to see if D:\OneDrive\Eagles_GrandReceiver exists. If it does run the code that was in file 1 and if n

:)

 

Batch Files Knowledge Base

Don't use batch files very much but one I find useful is for creating a list of files in a directory.
Just copy the text below into Notepad and save as Filelist.bat

dir /a /-p /o:gen >filelist.txt

When you run it from a folder it will create a Filelist.txt file,in the same folder, that lists all the files in that folder.Useful when you are too lazy to type all the files out yourself.

 

Batch Files Knowledge Base

Very nice and usefull thanks for contributing.

 

Batch file to ping network

No, batch files are extremely easy.

A "If" requires three extra steps.

Code is not how much you can put in, but how lite can you make it and still perform the functions.

So

@ echo off


ping 1.4.1.4 >a.txt

findstr /m "Request timed out" a.txt
if %errorlevel%%==0 (
echo Save our nets!!!
)

pause