Prev: <SCRIPT LANGUAGE="VBScript"> and <%%>
Next: Run setup.exe from netshare
From: White Horse on 23 Jun 2008 14:42
I want to nightly run a VBS Script in Scheduled tasks to open an
Access 2003 database and execute a macro.

The problem is that the database opens to a switchboard screen. I
need to open this database with a VBS script that mimicks opening the
database with {shift} open. My code:

dim accessApp
set accessApp = CreateObject("Access.Application")
accessApp.visible = True
accessApp.OpenCurrentDataBase("C:\ACF\Copied from Server\ACF.mdb")
accessApp.Run "Macro1"
accessApp.Quit

When this script executes, the switchboard is open, and the Macro1
can't be found (executed).

Thanks
 | 
Pages: 1
Prev: <SCRIPT LANGUAGE="VBScript"> and <%%>
Next: Run setup.exe from netshare