VB Forum / Database Access / September 2004

Sir,
I have a database in which a field is vehicle (you can see the example
below).... i want to search in that field..... if i search for car i
want to get all cars... what i will do...

I have a standalone recordset that my class object passes to the caller to
be filled out and returned.  This ensures that my class receives the data in
a format that can be easily worked with.  The following is the code to
created the recordset:

Have created small programme to compact a database:
   Dim je As New JRO.JetEngine
   ' Compacts database Data.Mdb to Data2.mdb.
   je.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data

Firstly, I am using VB5, a password protected Access 97 database, DAO3.6,
and ADO2.8
I am trying to overcome page level locking using an Access 97 database, by
using ADODB to open the database to use record level locking.

i am new to client server programming. kindly let me know
about how to do it using vb as FE and Access/Oracle as
backend. thanks for any help
sai

Does anyone have a good way to combine recordsets?  I have the following
code but, this is very memory intensive.
Function rsCombineRecordsets(ByVal rs1 As ADODB.Recordset, ByVal rs2 As
ADODB.Recordset) As ADODB.Recordset

Hello.  I am using VB 6 to execute a stored proc, which receives input
parameters.  I created a connection, command, and recordset with ADO.  The
CreatParamater method was used as metadata for type, direction, ect.  .  What
I don't know is if my parameters are not processed ...

Assume I have a database with 1 table (Table1)  with 1 Field (Field1)
and 4 records.  Two Records have the letter R in them and two records
are blank (Nulls allowed)
The SQL Statement

and sorry to bother anyone I am currently trying to write a database which
has the following fields
ID, Fname,Lname, Last_Visit, Today_Date
now, how do i update the database using VB ? to add the Today_Date and count

I need to insert image into the database via a stored procedure.
The database field is defined as image type, and the stored procedure
parameter is defined as image type:
CREATE PROCEDURE insert_image

I am having hard time understanding what I need to do to read from the
column that is set to TEXT datatype. The book example that I have uses
stored procedures and I still cannot understand it. I also don't think I can
use store procedure for this certain customer. Is there a way to ...

Can anybody kindly tell me the connection string for password protected
access 2002 database..
Thanks in advance
Ansari

If I connect to MySql using MyODBC (in the vb.net environment) can I
still use the various datagrids and bindings?  Or will I be hand
coding everything?

I would like to thank all the people that has helped me in solving my
problems with a list view....
I found it out where my problem was....
It was in the string....

I made improvements to a couple of programs that were previously
developed and had install packages built by other programmers. They
worked fine. On one program, I added crystal reports components. On
another, I added windows sockets dlls and tabbed sheets. The only