?
Solved

Access and isql like program

Posted on 1998-05-03
1
Medium Priority
?
285 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
cymbolic earned 200 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

770 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