VB Forum / Database Access / March 2006

I have a VB6 application that queries many DBF databases during program
execution.  The program is super slow and I tracked it down to Opening a
Recordset where the database is a DBF database.  It takes about 2 seconds to
make the connection...versus less than a half a second to ...

[font=Tahoma]I am making a database application for school and it run
fine there, where they use Windows XP SP2 (apparently a custom-buil
version) and Office 2003.  At home, I use Windows XP Professiona
without SP2 and Office 2003.  Whenever I load a form during run tim

I have a large CSV table that I'm accessing through ADO and the ODBC
text driver.
The ODBC text driver won't allow using ADO's Sort command, so I'm
sorting in the SQL Statement with an "Order By" clause. But, it sorts

i am new in vb so take it easy:)..and dont laugh..
Can we filter the filter with adodc ? In fact i am filtering data with
adodc.RecordSource = "SELECT * FROM tael WHERE "Name='test'"
and it's working, but when I refilter the result generated it dosent execute

I have a VB6 application which uses the ADO and MS Jet DB.  The user
may install the application in any directory he desires.  The DB will
be installed in the application directory.  The problem is that I
cannot find a solution to the ADO connection string which appears to

I hope this is the right forum for this question...  I have a need to access
(Search, read. write, etc...) FoxPro 2.5 tables (dbf/cdx) from Visual Basic
.Net (2005). Our current crop of VB6 apps use a product like codebase to get
at these old format files and unfortunately, we ...

I want to insert a graphics file (.gif) into a SQL column of type
varbinary(max).  I can do it with a stored procedures, but would prefeer to
use the tableadapter.  But this code:
Me.TblItemTableAdapter.Insert(1,strImageSource)

I have an Access database with a LOG table that has a DATE_TIME field that
is a Date/Time data type.  When I look in the database with Access there are
a bunch of records with the value 11/8/2005 11:28:15 AM in the DATE_TIME
field.  However, when I use ADO to .Find a record with ...

I want to create a VB6 form in which the user can add data into fields
created at runtime and this data must get stored in SQL database.
Now I am able to create a form which contains labels and textboxes on
runtime. The caption of the labels is recieved from the database.

Hello, I have a vb6 app that I need to query an access db and only
return those records that are within the last 24 hours. I have a field
that is date/time. I can query to a date but I need the last 24 hours.
Any Help ???

Hola, necesito convertir el siguiente código a ADO:
Dim DaoRs as Dao.recordset
 Set DaoRS = Forms!frmTLP!sfrmTLPVidaMes.Form.RecordsetClone
 DaoRS.OpenRecordset

Hi everyone, hope you can help with my dilema
I am currently using access 2000, what i am trying to do is on a form
select all the email addresses in a single field in a table and open
the email facility and place the adddresses in the (MailTo:)field

I used to automatically send emails from my MS Access database using MS
Outlook.  However my company does not support outlook so I have to look at
another way of sending emails.
I found that I can use something like CDO.  So I have this test sendemail

I'm a relative beginner to database programming in VB6.
I have a database with one table and 6 headings.
Does anyone know where I can download a simple
VB application which lets me do a search and display

Could someone share any ideas on the best way to deploy a vb6 application
with MS Access database and which installer package to use?
Thanks.