Re: Application ExitCode

From: Peter De Baets (info_at_peterssoftware.com)
Date: 06/15/04 

Date: 15 Jun 2004 15:27:50 -0700

Try this link: http://www.granite.ab.ca/access/autofe.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com

"Jeff" <KepGuruNo@SpamYahoo.com> wrote in message news:<1ccb201c4530a$503c3d40$a101280a@phx.gbl>...
> My Question:
> Is there anyway to specify an application ExitCode
> overriding the one generated by a normal exit?
>
> Situation:
> I've created a Windows Script that opens the MDB
> application on the local machine and waits for it to
> exit, storing the objects exitcode.
> In my Access Application, the first action is to compare
> the local mdb, to the main one on the server. If the
> local version is different, I exit Access, asking the
> user to update to the newest version.
>
> I hope to pass back to the script someway means to
> determine when to copy the new version of the MDB to the
> local machine. Since the script object WScript.Shell RUN
> gives me access to the objects EXITCODE it seems the best
> way to do it.
>
> Since Access closes without errors, the ExitCode is
> always 0. I tried raising an error and exiting, but the
> clean exit wipes my error replacing it with a 0.
>
> I've been doing something like this with a "startup" MDB,
> that just tests the version, copies the new one if
> needed, then opens the application. But this means
> starting 2 copies of access every time they open the
> application.
>
> Remove the No Spam to email me directly.
> Thanks
> Jeff

Relevant Pages

  • Re: Application ExitCode
    ... >> Is there anyway to specify an application ExitCode ... >> application on the local machine and waits for it to ... >> exit, storing the objects exitcode. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Checking if a Word file is open
    ... whether the local machine has the file open by seeing if there is an open ... If Err.Number = 429 Then Exit Function ... we cannot close a doc twice ... MsgBox sFile & " was open, ...
    (microsoft.public.scripting.vbscript)
  • Re: first ssh, then start copying
    ... >exit, remembering the location of the files I want to copy, and scp ... >from the local machine to get the files. ...
    (comp.security.ssh)