Running Access from VBScript

[GeorgeMar]

What is the correct syntax for running MS Access form
a .vbs script? Do all Win98 installations have the
WScript.exe installed for my script to run?

many thanks in advance!
george

 

[Tim Ferguson]

What is the correct syntax for running MS Access form
a .vbs script? Do all Win98 installations have the
WScript.exe installed for my script to run?

1) Why run Access from the script, when you can use the script to modify or
query the database directly using ADO or DAO? Much faster, easier to debug
and maintain and you don't need Access installed at all.

2) If you want to run a vbs script, you'll need wscript.ext or cscript.exe
to do it, unless you go all the way up to a HTA application and xml and all
that. You can also run vba code as an ASP if you have an IIS. I did try to
read about it but the more I looked the less sense it made.

B Wishes


Tim F

 

[GeorgeMar]

Thank you Tim

I already have the application developed in VBA and is
running well. The reason I am using the script is for
version control and the copying of files. After the
copying of files, it then runs the MS Access application.

george

 

[Tim Ferguson]

After the
copying of files, it then runs the MS Access application.

Aha, I see..

Tim F