Batch file for updating local frontend Access database copy

[BlueSpruce]

But if neither of them is on the client yet, then no.
A script or an exe file can specifically address this case.

But okay, it all depends on the environment you find at your customers' premises.

You mean, use an Access deployment tool, like Inno or SSE, to create an exe installer?

We created our own utilities library, that includes an Access deployment tool, by compiling vb.net programs. None of our users tinker with the hidden batch scripts. If they were to deviate from protocol and break something, they would pay dearly for us to fix it. We once had a creative user who changed the system date on his workstation to enter back dated transactions. That ex_user is no longer around

 

[AHeyne]

You mean, use an Access deployment tool, like Inno or SSE, to create an exe installer?

No, sorry for not specifying that. We use a self-created EXE (C#) as a startup program for our Microsoft Access application. This ensures that the necessary files are copied from the network to the client, searches for/finds the installation location of MsAccess.exe, checks whether it is 32-bit or 64-bit, creates a trusted folder entry if necessary, and more.

We created our own utilities library, that includes an Access deployment tool, by compiling vb.net programs. None of our users tinker with the hidden batch scripts. If they were to deviate from protocol and break something, they would pay dearly for us to fix it. We once had a creative user who changed the system date on his workstation to enter back dated transactions. That ex_user is no longer around

Were you referring specifically to me? If so, I'm afraid I don't quite follow...

 

[AHeyne]

Personally I would never issue a batch file to a client for any reason whatsoever.
There could just be some clown who alters a batch file, causing a sequence of errors that I would be obliged to fix. I would always create the batch file and then convert it into an EXE file before issuing.

If you use a PowerShell script you could sign it with a certificate and thus protect it against execution if it has been modified.

 

[BlueSpruce]

Were you referring specifically to me? If so, I'm afraid I don't quite follow...

No, was just explaining what we use over here.