VB Forum / Database Access / February 2005

I got the connection and everything alright.
Here's a sample code:
Private Sub cmdUpdate_Click()  
   If optN.Value = -1 Then

Im trying to select and add only not existing values
(records) from a csv-fromatted file into an access
database using:
strSQL = "INSERT INTO tbl_hosts SELECT "& HostName &" As

I have a client that is returning >600K rows from a sql server using a VB
application.  I am referencing ado 2.6 in the app but he has windows xp sp2
(I think that has ado 2.8???).  When the data is fetched I use GetRows to
poplulate an array.  As soon as GetRows is called I get ...

I'm running VB5, and battling to write code that checks for duplicate records
before saving it to the database ... I've got myself in a knot trying to get
AddNew, Update, FindFirst to work together. Is there anyplace I can find some
sample code illustrating some simple examples

Hi.  I have searched extensively for this answer, and haven't found
much.  What I want to do is execute a bacth of sql statements in a
single call.  Something like this:
SELECT *

I have a few ramp-up up quesitons on using VB.net to access FoxPro tables.
Can pay using PayPal. Please send me an email at michael@erlewine.net.
Thanks,
Michael Erlewine

I have an ADO resordset with no connection to a database. I only added some
fields for the resordset. Now I want to use query to search rows in the
resordset but I don’t know how. I even don’t know how to write the query
because there is no table. Is there any sample code for ...

I am trying to create a query that can be used to run several reports.  I
am not sure how to tell the report to select only the records where the
fieldname returns only the records for that report.
query fieldname = "8"

Hi. I'm trying to fix some ancient code and running into an ADO problem of
some sort. The app is in VB6. I have this code (which some lines omitted):
Private Function InvokeSP() As Boolean
   Dim Conn As New ADODB.Connection

I have a COM+ component which fetches records asyncronously, then cancels at
some point when XXXX number of records are retreived.
The problem that I'm having is that after accessing any properties after
calling the Recordset.Cancel to cancel the asynchronous fetch (opened via ...