Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (https://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   MS Access and Install Shield Developer (https://www.kinook.com/Forum/showthread.php?t=87)

Too_Tall_Crown_Victoria 05-02-2003 10: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.

Thanks

Tom

kinook 05-02-2003 03: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 10: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,

Kevin

Too_Tall_Crown_Victoria 05-05-2003 10:28 AM

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

Tom


All times are GMT -5. The time now is 06:12 AM.


Copyright © 1999-2023 Kinook Software, Inc.