Kinook Software Forums

Kinook Software Forums (
-   [VBP] Third Party Tools (
-   -   MS Access and Install Shield Developer (

Too_Tall_Crown_Victoria 05-02-2003 11:35 AM

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.



kinook 05-02-2003 04:28 PM

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 05-02-2003 11:00 PM

ADO example with generic routine for future use
1 Attachment(s)
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,


Too_Tall_Crown_Victoria 05-05-2003 11:28 AM

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


All times are GMT -5. The time now is 01:27 AM.

Copyright 1999-2019 Kinook Software, Inc.