VB Forum / Database Access / July 2005

I am working on a project that uses many forms and many tables. I wanted to
simplify things by using only one SQL server data adapter, so I did a multi
table select and loaded it into a data set. There are 15 tables (0-14) and
right now I'm working of my second form,  form one ...

I am using the routine below to mail merge my contacts to MS word 2003.
However it seems to merge all records and not the current record.
Please could you help me so that it only merges the current record?
Thanks and see below.

I wanna import data from foxpro to SQL Server 2000. I use ADO component and
to be looping. but this way is very slow. it can take 8 minutes for 32500
record at PentiumIII. Can you give me solutions so I able to import <1
minute?

I am in need to work with VB with database as
FielMaker 6.0. please assist me
to make a connection string for connecting Vb to Filemaker6.0
please provide the connection string.

ERROR: run-time error 2147467259 unrecognized database format <<path to
database>>
the above error message is received when my application is installed on a
machine with the following:

I am in need to work with VB with database as
FielMaker 6.0. please assist me
to make a connection string for connecting Vb to Filemaker6.0
please provide the connection string.

If we open Conn1 it works quickly in retrieving recordsets.  Then open Conn2
and Execute an Update on the Conn2.  Afterwards and Select that we execute
on Conn1 is slow.  We then need close and reopen Conn1 to get the speed
back.

We have a VB6 application that currently uses ADO 2.5. When saving records
via a stored procedure, ADO doesn't catch the deadlocks errors when they
occur. We've tried ADO 2.6 and 2.8 too.
What are we missing?

I have a call to stored procedure that I have added to each of my SQL
Server stored procedures to update a table with statistics on how often
that procedure is called, etc.
It works just fine except when it is called by an ADO open recordset

Can you help? I'm trying to use ado to convert an Access 95 (or Jet Version
3 to be more accurate) database to Access 2000 (or Jet Version 4) in code but
I'm not really sure how to go about it. Anyone got any ideas I could try?
Any help greatly appreciated.

I have a JET table that I'm trying to access through Visual Basic 6 using ADO.
I'm trying to filter the table looking for only certain Product Lines
1.    I run the following code and it filters the correct records for me
      Q = "(Key = 1)"

Public sub txtGenReport_Click()
AcceptRecordSet(rsABC)
End Sub
Private sub AcceptRecordSet(inRS as adodb.recordset)

I tried to use:
 Dim dbIndex As ADODB.Connection
 Set dbIndex = New ADODB.Connection
 On Error GoTo 0

Thanks for your reply.
Here is the details of my architecture. My application uses Visual
Basic 6.0 as Client and SQL Server as Back End.
What happens to my users is when the application is kept idle for quiet

how to print ms access reports from vb6?
some code sample please.
tia,
mcnewsxp