[AccessD] One Accdr (front end) for each User's PC or Share theAccdr file on the File Server

Ah-ha! So you're using scriptiing, not just a simple cmd/bat file.

-- 
Stuart

On 21 Oct 2014 at 23:24, Darryl Collins wrote:

> Here is the snippet of code that does the read / copy bit if you are
> interested.
> 
> ' Read the version text files and compare them.
> if FS.fileexists(destinationPath & "version.txt") then
>  destTxtVersionFile = GetFile(destinationPath & "version.txt")
>  sourceTxtVersionFile = GetFile(sourcePath & "version.txt")
>  copyTheFile = not (destTxtVersionFile = sourceTxtVersionFile)
> else
>  copyTheFile = true
> end if
> 
> if (FS.fileexists(destinationPath & applicationname & ".accde") =
> false) then copyTheFile = true	
> 
> if copyTheFile then
>  FS.CopyFile sourcePath & applicationName & ".accde", destinationPath
>  FS.CopyFile sourcePath & "version.txt", destinationPath
>  FS.CopyFile sourcePath & "Icon.ico", destinationPath
>  copyOtherSpecifiedFiles
> end if
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan Sent: Wednesday, 22 October 2014 9:54 AM To: Access
> Developers discussion and problem solving Subject: Re: [AccessD] One
> Accdr (front end) for each User's PC or Share theAccdr file on the
> File Server
> 
> Incidentally, you don't actually need to "read" the two files to
> compare them.
> 
> The simplest way is something like:
> 
> FC AppVersion.txt \\server\database\AppVersion.txt > nul IF errorlevel
> 1 COPY....
> 
> 
> 
> On 21 Oct 2014 at 22:19, Darryl Collins wrote:
> 
> > Hi Arthur,
> > 
> > I use two text files, one stored locally and one of the server.
> > 
> > These two text files have nothing in them but the version number
> > 
> > The launcher script reads the contents of both and if they match it
> > just opens the local FE version of Access normally.
> > 
> > If the version numbers do not match then the script copies the
> > latest version.txt file and the latest Access FE from the server and
> > replaces the local copies.
> > 
> > It then open the local (updated) version of the FE.
> > 
> > Cheers
> > Darry.
> > 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur
> > Fuller Sent: Tuesday, 21 October 2014 8:00 PM To: Access Developers
> > discussion and problem solving Subject: Re: [AccessD] One Accdr
> > (front end) for each User's PC or Share theAccdr file on the File
> > Server
> > 
> > Darryl,
> > 
> > That's the approach I was thinking of. How do you check the version
> > numbers? Do you have to open each copy of the FE to find that out,
> > or do you have some other means of storing the version number?
> > 
> > Arthur
> > --