VB Forum / Database Access / April 2006

Sorry for such a generic subject.  I have been searching for a solution
for this error for a few hours now and my eyes have glazed over.
I have a MS Access 2000 database connected to a Oracle 10g database.
On this system I have several stored procedures which I call using ADO,

I am trying to use an OLE field in a microsoft access table and bind it
to a picture box control
in visual basic 6 .
picture1.datasource=datas

In an application that uses Jet with an MDB file, is it best to open one
connection as the beginning of the application and keep it open until the
application closes, or open and close a connection for each command (SELECT,
UPDATE, etc.) that accesses the database?

I have an Access 97 mdb that I'm opening with ADO 2.8 SP1 through a VB6
application.
ADO or the mdb itself behaves weirdly!!
When I say SELECT TOP 10 FROM mytable, it gets 5 records. When I say SELECT

i have damaged access database, any one know good software to fix it?

I am using SQL ADO Connection in my application to connect from VB 6 SP4 to
SQL Serve databases (MSDE, SQL Server 2000) as follows:
DB.ConnectionString = "Provider=" & DBProvider$ & ";Server=" &gDBServer$ &
";UID=" & DBUserID$ & ";PWD=" & DBPassword$ & ";DATABASE=" & DBName$

I have a couple of old apps in VB5 which I need to keep on working on
for a little longer.  (Yes, I am upgrading them to .NET).  I
uninstalled MS Office 97 from the machine which has VB5 installed on
it, and installed MS Office 2003.  VB5 is now broken - it will not run

I want to find a sql query for the following case :
ID    ID_client    ID_prodnr
  1    1                3
  2    1                5

i write an db application to insert many records into database.
While inserting records, i want to show some text of status on a form.
But when inserting records, most of CPU resources contribute to the database
I/O.

I've read on various threads that even when, for Access, a date time field
is specified that midnight is assumed for the time element when no time is
specified. I've generated DAO and ADO datasets to try and get hold of this
raw data but to no avail. Is there any way of getting out ...

i create a connect call ETCon using ADODB, And have a ADODB.RecordSet call
ETRS, another build in method i can used to count the number of table ?

I have a strange problem with reading an Excel spreadsheet using ADO
within VB6:  there is one column that sporadically returns "Null"
despite the presence of data.  I want to read it in as alpha, even
though the value in the first row of data is numeric.

The DB is MySQL 5
VB6
Simple... How do i call a stored procedure?
Connection string is:

The table is storing 0 for false and -1 for true
The following line of code will displays as Yes No but I can't work out the
check box
Datagrid.DataFormats.Item(2).Format = "Yes/No" ' or "True/False"

Okay I am trying to display records in an access database.  It starts
displaying the records and about 3/4's of the way down it dumps out to
a type mismatch.  Anyone have any ideas?
Here is my script.