gary.newport
Registered User.
- Local time
- Today, 00:27
- Joined
- Oct 14, 2009
- Messages
- 79
I have an Access file that is simply the data tables and this is in a fixed location (s:\data, with the name data.accdb).
I have an interface file that can be copied by any and all users anywhere they wish (called interface.accdb).
I am making changes to the interface and will continue to do so, therefore I have been working on a deployment tool that works like this:
I could use the data tables and yet what if two people wish to update at the same time? I could potentially end up with mis-information.
I have an interface file that can be copied by any and all users anywhere they wish (called interface.accdb).
I am making changes to the interface and will continue to do so, therefore I have been working on a deployment tool that works like this:
- interface carries version number and link to data table, which contains latest version number. If these two differ then an upgrade is implemented
- The old interface opens an update file (an Access form and a tiny amount of VBA) and closes itself
- The update file copies the new interface over the old interface, then opens the new interface
- The new interface has the same version number as the data file implies and so the new interface opens up as normal
I could use the data tables and yet what if two people wish to update at the same time? I could potentially end up with mis-information.