May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
if not exist "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" ( set SourceDB=KNOW64.accdb ) else ( set SourceDB=KNOW.accdb ) if not exist "%UserProfile%\My Documents\FEO_TRANSFER\DBS" md "%UserProfile%\My Documents\FEO_TRANSFER\DBS" xcopy \\fkpdfs05\i\SD\FEO_TRANSFER\DBS\%SourceDB% "%UserProfile%\My Documents\FEO_TRANSFER\DBS\" /d /y start MSACCESS "%UserProfile%\My Documents\FEO_TRANSFER\DBS\%SourceDB%"
FOR /F "usebackq tokens=3*" %%A IN (`REG QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths \MSACCESS.EXE\Path" /v ValueName`) DO ( set appdir=%%A %%B ) ECHO %appdir% pause
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Bat file to insert Multiple Registry Keys||20||521|
|Batch FIle delete files with particular date||10||130|
|Need to delete empty sub dirs but not include the directory itself||10||96|
|Compare two files with arithmetic not 'fc' file compare method||26||50|
Join the community of 500,000 technology professionals and ask your questions.