I'm using some .bat code I found on these forums from a few years ago to compare user's front ends to the master front end:
Code:
@echo off
REM file used to automatically update the Database when updates are available.
if not exist %userprofile%\appdata\local\redirect\ui1.3.2013.accdr echo Database needs to update to newer version.
if not exist %userprofile%\appdata\local\redirect\ui1.3.2013.accdr pause
@echo off
if not exist %userprofile%\appdata\local\redirect\ui1.3.2013.accdr if exist %userprofile%\appdata\local\redirect\ui*.accdr del %userprofile%\appdata\local\redirect\ui*.accdr
if not exist %userprofile%\appdata\local\redirect\ui1.3.2013.accdr Robocopy \\DUI_NAS\data\database %userprofile%\appdata\local\redirect ui1.3.2013.accdr
Start MSAccess.exe /runtime %userprofile%\appdata\local\redirect\ui1.3.2013.accdr
Exit
It does its job well, but if I run it on a test computer I get a warning about the location not being trusted every time. I know you can manually add that location to trusted for each computer, but I'd rather do it as part of the batch if possible. Anyone done this successfully before?
Alternatively, if there is a better approach that does not run into this issue, I am happy to try that as well. I was a bit confused by the approaches that are self-contained in Access as they tend to be much more complicated.