Solved

Access and isql like program

Posted on 1998-05-03
1
276 Views
Last Modified: 2006-11-17
Is there a program for access97 that performs
the same type of functions the isql does.  
ISQL is a command-line utility for running queries against
a SQL Server database.  Of course, it needs to be able
to do select, insert, update and deletes from the command
line.
0
Comment
Question by:ivanh
1 Comment
 
LVL 9

Accepted Solution

by:
cymbolic earned 100 total points
ID: 1959960
I don't know of one commercially available, but it is easy to write something like this in VB.  I have written a number of "SQL" processors in VB that work from external SQL streams.  It's a trivial set of code.  You just open a connection to the specified database, examine the command, and either open a recordset or perform an execute method - it's really that simple in VB.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now