Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access and isql like program

Posted on 1998-05-03
1
Medium Priority
?
291 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 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

580 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