MS Access and Install Shield Developer

[Too_Tall_Crown_Victoria]

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

[kinook]

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.

[kevina]

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

[Too_Tall_Crown_Victoria]

Thanks Kevina, that script is just what I am looking for.

Tom