Batch file assistance needed

ordnance1 · Sep 12, 2022

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.

Below is my feeble attempt but it does not seem to work. I get no error messages.

Is this even possible?

Bree · Sep 12, 2022

ordnance1 said:
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.

Below is my feeble attempt but it does not seem to work.

Welcome to Eleven Forum

Try this at the start of the batch file....

Code:

@echo off
set DRIVE=none
if exist "D:\OneDrive\Eagles_GrandReceiver" set DRIVE=D
if exist "E:\OneDrive\Eagles_GrandReceiver" set DRIVE=E
if %drive% == none echo Drive not found . . .
If %drive% == none pause
If %drive% == none exit
Echo Drive found as %DRIVE%

From this point on wherever you would have used D or E in the batch file you can use %DRIVE% instead.
eg: mkdir %DRIVE%:\FECopy instead of mkdir D:\FECopy

ordnance1 · Sep 12, 2022

Thank you so much. Here is the final code:

Code:

@echo off
set DRIVE=none
if exist " C:\Users\"%USERNAME%"\OneDrive\Eagles\Distribution " set DRIVE=C
if exist "D:\OneDrive\Eagles_GrandReceiver" set DRIVE=D
if %drive% == none echo "Drive not found . . ."
If %drive% == none pause
If %drive% == none exit
Echo Drive found as %DRIVE%
mkdir %DRIVE%:\FECopy_GrandReceiver

DEL %DRIVE%":\FECopy_GrandReceiver\Eagles_GrandReceiver_Copy.accdb"

COPY %DRIVE%:\OneDrive\Eagles_GrandReceiver\Distribution\MasterFile\Eagles_GrandReceiver_Master.accdb "%DRIVE%:\FECopy_GrandReceiver\Eagles_GrandReceiver_Copy.accdb"

Start %DRIVE%:\FECopy_GrandReceiver\Eagles_GrandReceiver_Copy.accdb"

EXIT /b

ordnance1 · Sep 12, 2022

I amended the code just a little bit to remove the file when the database closes.

Is there anything that can be added to the batch file to minimize the cmd.exe window. I do not mind it being on the taskbar but do not want it on the screen.

Code:

@echo off

set DRIVE=none
if exist " C:\Users\"%USERNAME%"\OneDrive\Eagles\Distribution " set DRIVE=C
if exist "D:\OneDrive\Eagles_GrandReceiver" set DRIVE=D
if %drive% == none echo "Drive not found . . ."
If %drive% == none pause
If %drive% == none exit
Echo Drive found as %DRIVE%
mkdir C:\FECopy_GrandReceiver

DEL C:\FECopy_GrandReceiver\Eagles_GrandReceiver_Copy.accdb"

COPY %DRIVE%:\OneDrive\Eagles_GrandReceiver\Distribution\MasterFile\Eagles_GrandReceiver_Master.accdb "C:\FECopy_GrandReceiver\Eagles_GrandReceiver_Copy.accdb"

Start /wait C:\FECopy_GrandReceiver\Eagles_GrandReceiver_Copy.accdb"

DEL C:\FECopy_GrandReceiver\Eagles_GrandReceiver_Copy.accdb"

EXIT /b

Bree · Sep 12, 2022

ordnance1 said:
Is there anything that can be added to the batch file to minimize the cmd.exe window. I do not mind it being on the taskbar but do not want it on the screen.

No, not in the batch file, but if you create a shortcut to run it you can set it to be minimized when you start it from the shortcut. You could put this shortcut in the user's Start Up folder if you want it to run automatically when the sign in.
C:\Users\<username>\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup

If you are starting it from another script, then you can use the Start command with a /min argument, like this:
start /min c:\temp\test.bat

NB: however you do it, you'll want to remove that PAUSE command if no one is going to be able to see it and respond!

Batch file assistance needed

ordnance1

New member

My Computer

System One

Bree

Well-known member

My Computers

System One System Two

ordnance1

New member

My Computer

System One

ordnance1

New member

My Computer

System One

Bree

Well-known member

My Computers

System One System Two

Similar threads

Latest Support Threads

Latest Tutorials