VB Forum / Database Access / February 2006

I always have problems updating a recordset and keeping the recordset open to
continue working on other records. I use the Update method but I find that
until I close the recordset the update does not show at all.
What am I doing wrong?

I'm trying to search Access97 database with VB6 and using the SQL Query
Designer.
I have tried to put under criteria, " = #2005#" , or maybe "> # 2005#",
ect..

I am connecting to Oracle9.2 database from VB6.0 using MSDAORA provider. I
am using ADO2.5.
When I try to access a blob column of oracle I am getting the below
mentioned error.

I'm really not sure this is the place to ask a question or not...
I am completely new to VB.net as I have been recently asked to make a few
adjustments to some existing programs. I am attempting to add a few columns
to an existing program however after making the changes to the MS ...

I am trying to compare between a text field and database field. I had
msgbox for both value and they are what I expected. However, the
evaluation does not take place correctly. Please let me know what am I
doing wrong.

I receive the following error when trying to update a table after editing.
    System.InvalidOperationException was unhandled
    Message="Update requires a valid UpdateCommand when passed DataRow
collection with modified rows."

I'm have tried to execute the following queries against an Access 2000
database:
   Select * From EvalT Where OldID LIKE 'TEST001%'
   Select * From EvalT Where OldID LIKE '%TEST001%'

I'm not clear about when to use
Dim rs as ADODB.Recordset
Set rs="something"
vs

Can someone tell me why this isn't working:
Using ADO 2.8 connecting to an Access 97 DB.
sSQL = "SELECT [04041_PRODUCTS].[Haddad Code], [04041_PRODUCTS].[Color
Description], [04041_PRODUCTS].[Original Size], [04041_PRODUCTS].[Current

I have an VB6 application that uses ado to connect to a database in SQL
Server 2000.  It uses a direct connection with ado.  The provider I'm using
is "sqloledb".
When I run a query, assigned to that connection sometimes it completes

I have a program developed in Visual Basic 6 that uses an Access
database.  The program has almost 500 users now and someone called
today asking about a run-time error I have never seen before.  It is:
"Run-Time Error 3706: Provider cannot be found. may not be properly

In the texts that I have they discuss using WHERE with SELECT, UPDATE and DELETE, but never mention
using it with INSERT INTO.  I have 3 tables and was wondering if the WHERE reserved word
should/could be used with the INSERT INTO during the save of the record into the three ...

I want to know where i can get the compelete informatio about ADO in VB.
site name or link name