Deploying a database file for users
Posted on 2011-10-26
Here's the situation,
There is a database (Microsoft Access) file that users use to access a SQL back end.
The users generally have this file on their desktops of their computers. Some users use a RDP (Terminal) server.
Unfortunately, each user has to have his own file (we can't link all users to the same file), so the same file resides on 100 users desktops, terminal sessions, etc.
Periodically, we need to update the file when a new database version is released. When this happens, we have a couple of batch scripts to copy the new file and overwrite the existing one.
Was wondering if anyone had any suggestions as far as ways to improve this. Right now we have to create a new batch file for every user (and then have a master batch file that calls all the sub bat files).