Batch file to copy Master copy to all users

[Kayleigh]

Hi,
I'm attempting to distribute my system to all users on the LAN. I was advised to write a batch file which copies the Master copy from a shared location onto the user's appdata/local folder and a shortcut to their desktop (including a specific icon for the shortcut).
Any pointers or sample code to start me off please?

 

[theDBguy]

Hi. Have you seen this one?

MS Access - Deploying Your Database | DEVelopers HUT (devhut.net)

 

[arnelgp]

there is discussion here about autoUpdating the FE.
autoupdate Front End | Access World Forums (access-programmers.co.uk)

 

[Kayleigh]

@arnelgp - I use a similar autoupdater to update users' front end whenever the master is updated. However I am struggling with doing the initial install on all users.

 

[Cotswold]

If you are issuing a batch file, I suggest that you download a Batch To Exe program.

There are a few about and some are free. It takes your batch file and converts it into an executable.
The advantage is that your users cannot read or amend the instructions. Sometimes you don't want
a user to know where all of the files in your application are. Or you simply want to prevent tampering
by some enthusiastic amateur.

Clearly the last thing you want is some bright spark amending paths, which may result in problems for you later.

 

[Cronk]

@Pat, is that batch code off the top of your head? How do you delete a sub folder immediately after creating the parent?

md c:\DwgLog
del c:\DwgLog\DrawingLog.accdb

 

[Cronk]

Sorry I should have asked why do you delete a file in a new folder that you have just created. If you created a
new folder, I can't understand how there can be a file in that folder to delete?

 

[Cronk]

OK