Create a distribution mechanism
This is for applications that use Access as a front-end to SQL Server.
Create a distribution mechanism in Access where:
- Developers can release a new version with a version number
- It automatically creates a secure accde and places it on a file server
- When a user copy of an accde starts up, the current version can check for a new release
- If a new version exists, Access closes, the new version is copied, and the new accde restarts
I have existing code for much of this for my main applications. But I have to rely on vbs scripting to handle the file copy portion of this. It would be nice if it were built in.
Access is great in that there is only accdb file to update to release a new front end to users.