I had one of those "what a good day" days today. Came up with a working solution to a problem using AMS.
Problem - A new VB database front end is very sluggish because all the clients are running it off the server. Tried copying it onto a local hard drive and running it from there which solves the problem, but then how to be sure that clients are using the latest version?
Resolution - Open it with an AMS app that checks for then creates if necessary a known folder in root of C: and does same for the exe file in that folder (this is copied across from the server if not present). If it is present then check on the server file attributes creation date compared with the file on C:. If the one on the server is later than the local copy then overwrite it and finally open it and close AMS.
Took about 45 minutes to produce a working solution when the boss had said we'd need a couple of days to resolve it - well says I, don't I keep telling you that AMS5 is the dogs wotsits
Problem - A new VB database front end is very sluggish because all the clients are running it off the server. Tried copying it onto a local hard drive and running it from there which solves the problem, but then how to be sure that clients are using the latest version?
Resolution - Open it with an AMS app that checks for then creates if necessary a known folder in root of C: and does same for the exe file in that folder (this is copied across from the server if not present). If it is present then check on the server file attributes creation date compared with the file on C:. If the one on the server is later than the local copy then overwrite it and finally open it and close AMS.
Took about 45 minutes to produce a working solution when the boss had said we'd need a couple of days to resolve it - well says I, don't I keep telling you that AMS5 is the dogs wotsits
Comment