Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] Third Party Tools

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 05-02-2003, 10:35 AM
Too_Tall_Crown_Victoria Too_Tall_Crown_Victoria is online now
Registered User
 
Join Date: 01-14-2003
Posts: 44
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
Reply With Quote
  #2  
Old 05-02-2003, 03:28 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
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.
Reply With Quote
  #3  
Old 05-02-2003, 10:00 PM
kevina kevina is online now
Registered User
 
Join Date: 03-26-2003
Posts: 825
Cool 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
Attached Files
File Type: bld access-ado-example.bld (1.9 KB, 1775 views)
Reply With Quote
  #4  
Old 05-05-2003, 10:28 AM
Too_Tall_Crown_Victoria Too_Tall_Crown_Victoria is online now
Registered User
 
Join Date: 01-14-2003
Posts: 44
Smile Thanks

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

Tom
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 02:15 PM.


Copyright © 1999-2023 Kinook Software, Inc.