Solved

Access and isql like program

Posted on 1998-05-03
1
277 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

912 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

25 Experts available now in Live!

Get 1:1 Help Now