Is this a good/reliable/appropriate method for updating FE's?

[David Mitchell]

I have a split app (BE on server - separate FE on each workstation)
which is being upgraded with various whistles and bells. To upgrade
the FE's I email a small database with an instruction to launch
(rather than detach) it.

This database has an autoexec macro which runs code.

The code is as follows:-

(where fOSUsername is the logon name for Windows NT, code from
http://www.mvps.org/access/api/api0008.htm courtesy Dev Ashish)

Function copynewapp()

Dim Sourcefile, DestinationFile

Call killold
Call fOSUserName
Sourcefile = "H:\Bus Support\TaskTracker.mdb" ' Defines sourcefile
name.
DestinationFile = "C:\WINNT\Profiles\" & fOSUserName & "\Desktop\Task
Tracker.mdb" ' Define targetfile name.
FileCopy Sourcefile, DestinationFile ' Copy source to target.
End Function

Function killold()

On Error GoTo Err_killold
Contains various Kill statements to delete a number of possible
files
including shortcuts relating to app.

Exit_killold:
Exit Function

Err_killold:
Resume Next

End Function

Function fOSUserName()
code from http://www.mvps.org/access/api/api0008.htm courtesy Dev
Ashish

End Function

There is also functionality to prevent database being opened if FE
version is not correct.
Your thoughts and comments are appreciated.

[pjac]

Try Windows 2000 Server and above, MSI's. See Microsoft.com or use
Lanovision Prism Deploy to send out the FE file to your users.

pjac

[Jeremy Wallace]

Are you doing much other than copying the version on the server to the PC? I
might be missing something...

I do this chore with batch files. There are a couple of pages on my method
in the Developers' section of my website. The basic notion is that I check
to see if the user has the latest version and if not I copy a new one from
the server to the PC. Works quite well in my environments.

Jeremy

--
Jeremy Wallace
AlphaBet City Dataworks
http://www.ABCDataworks.com
"David Mitchell" <da**************@talk21.com> wrote in message
news:c3**************************@posting.google.c om...

I have a split app (BE on server - separate FE on each workstation)
which is being upgraded with various whistles and bells. To upgrade
the FE's I email a small database with an instruction to launch
(rather than detach) it.

This database has an autoexec macro which runs code.

The code is as follows:-

(where fOSUsername is the logon name for Windows NT, code from
http://www.mvps.org/access/api/api0008.htm courtesy Dev Ashish)

Function copynewapp()

Dim Sourcefile, DestinationFile

Call killold
Call fOSUserName
Sourcefile = "H:\Bus Support\TaskTracker.mdb" ' Defines sourcefile
name.
DestinationFile = "C:\WINNT\Profiles\" & fOSUserName & "\Desktop\Task
Tracker.mdb" ' Define targetfile name.
FileCopy Sourcefile, DestinationFile ' Copy source to target.
End Function

Function killold()

On Error GoTo Err_killold
Contains various Kill statements to delete a number of possible
files
including shortcuts relating to app.

Exit_killold:
Exit Function

Err_killold:
Resume Next

End Function

Function fOSUserName()
code from http://www.mvps.org/access/api/api0008.htm courtesy Dev
Ashish

End Function

There is also functionality to prevent database being opened if FE
version is not correct.
Your thoughts and comments are appreciated.

[Albert D. Kallal]

Tony has free updater that works by checking the date. It is all automatic,
and does not require you to modify, or even check version numbers.

Check out:
http://www.granite.ab.ca/access/autofe.htm

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@msn.com
http://www.attcanada.net/~kallal.msn