VB Forum / Database Access / August 2004

Something strage happens using FilePattern. I use the function below to
display the names of pictures in a File Listbox.
Private Sub Text1_Change()
File1.Pattern = Text1.Text & "*.*"

We are in the process to develop a new VB6/SQL 2000 application (do
not ask why not .net, our company policy is to use VB6), which will
have over 3000 users to access the database (50GB data) and perform
heavy add/update on one table. Without the privilege to have a

I am using ADO with a Datalist, Adodc and DataGrid.  Using the following
code in the Datalist (onclick event) works great:
strQuery = "Select * FROM dbMileage " _
              & " WHERE mNameID = " & DataList1.BoundText

Can anyone give me an example of how to code the following situation:
I have a float array of 10000 items that I use to plot a graph with.
I want to store this array in 1 field in a SQL 2000 table and be able
to retrieve it back into an array on demand.  The only data type that

I have used SQL to sort out the records, but I want to sum up the value of
all the records for a field name , How can I do that ?
Thank you
Jack

Have anyone know how to connect to AS/400? Do I need some OLE or ODBC
driver? If so, where can I download it?

I would like to know if it is possible to optimize the ODBC driver.  I
have an application that use a MsAccess DB and the incoming flow to the
DB is pretty fast.  It is possible to have 100 new entry per second or more.
How do I speed up the MsAccess write process, is it through ...

In DAO, you can create an ACCESS .MDB database using the CreateDatabase
method in the Workspace like the following:
  Dim dw As Workspace
  Dim dbNew As Database

Question:
   When you Select all records in a table to a Record Set are ALL the
records stored in the record set (which I assume is in memory) even if there
are millions of records?

I have an access database where one of the columns (called "Drawing") is an
OLE-object. (The objects are images : gif and tif)
I use the 'OleDB'-environment to access the database
In a first instance, I just want to display the images on a form in a

I have developped a program in Visual Basic 6.0 using MS Access database.
I have created all my reports through Data Environment where I have
entered the location of my database file (for e.g c:\project\app\test.mdb)
in the Connection properties.

Tough SQL question
I have two tables that are joined in a one-to-many relationship. The primary
table on the one side holds data relative to patient intubation and we'll
say for the sake of argument it has the following data:

I currently write small database programs the hard way (random file)which
results in a binary data file.
I have noted how easy it is to use a access(.mdb) file with SQL etc.
question:

I'm new to ADO programming and database programming in general.
I'm trying to use the Data View Window in VB6 to modify a SQL Server 2000
database. I can connect to the database using a Data Link using the "OLE DB
Provider for SQL Server" provider, and I can see the tables in the ...

I'm new to working with databases in VB6 and have what is probably a
simple question, but I can't seem to figure out the answer on my own.
I have a program where the load event of frmMain opens a database and
recordset as a dynaset using the following code: