#1
|
|||
|
|||
MS Access and Install Shield Developer
I was wondering if anyone had written a vb script or command line interface to MS Access 2000 to run a query or update a table?
Also does Visual Build support Install Shield Developer for creating MSI applications? I am assuming this would have to be done command line but I am just asking. Thanks Tom |
#2
|
|||
|
|||
You can call DAO or ADO from script code to manipulate an Access database; I don't have a sample handy, though.
The InstallShield action in VisBuildPro does support InstallShield Developer. It wraps its command-line interface. |
#3
|
|||
|
|||
ADO example with generic routine for future use
The attached sample file (Access-ADO-Example.bld) has a single step that executes a couple different sql statements against a sample database.
To use, simply change the value of the ACCESS_DB_PATH project macro to point to a valid, existing Access .mdb file. The RunSql() script function is in projects scripts and can be used as is generically. I would recommend changing it to a global script for future use. Hope this gets you going! Good luck, Kevin |
#4
|
|||
|
|||
Thanks
Thanks Kevina, that script is just what I am looking for.
Tom |
|
|