Open an application using script

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rob Rutherford (rob_at_xyz.invalid)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 15:45:56 +0100

I'm using Win XP Home and have Microsoft Office Professional installed. I'm a complete
novice as far as VB Script is concerned and would be grateful if someone could tell me
whether you can use it to open an Access database (in MS Access)?. I tried setting up
an object variable using CreateObject and then called the OpenCurrentDatabase method
but this didn't work. Does the object variable go out of scope when the script finishes thus
closing Access even if it was opened momentarily?

I don't want to have to write a VB program to do the job because I want something simple
that doesn't require installation. The reason that I want a user to run code rather than simply
open the Access database is because I want to check that the latest version of the application
resides on the user's machine and if not replace it with the latest version copied from the server.

Any advice would be appreciated.

Relevant Pages

  • Re: ADO and blank fields problem
    ... > Charles E Finkenbiner wrote: ... >>My script is a front end for an MS Access database. ... not the internet. ...
    (microsoft.public.scripting.vbscript)
  • Re: Newbie..Needs Help
    ... here is the website which holds the data I require ... put in this parameter or these are the meeting tracks ... I am enjoying a script that was written for me and its purpose is to ... collect data from a web site and puts it into a access database table. ...
    (comp.lang.python)
  • OWA usage analysis script
    ... For this script, you need an access database with the following fields ... ' From the book Inside Active Directory, ... Set objConnection = CreateObject ...
    (microsoft.public.exchange2000.clients)
  • Installer and Access database sync
    ... How do I make an installer or script that set up the Access database ... syncronization relationship between the desktop and the device? ...
    (microsoft.public.pocketpc.developer)
  • Installer and Access database sync
    ... >How do I make an installer or script that set up the ... Access database ... >syncronization relationship between the desktop and the ...
    (microsoft.public.pocketpc.developer)