VB Forum / Database Access / June 2004

I have a vb6 application that connects to a FP6 DB.
If I use the following the update take less then a second to complete:
 SQLstr = "select * from orders where jobno = '" & VOrderNo & "'"
 With tmpRS

I'm performing SELECT and INSERT statements using ADO and the
connection.execute method.  My select statement may return up to 20k
rows; is there any way to get a % complete event to fire?
Same question with regards to large INSERT INTO statments (such as

I'm using VB6, ADO & SQL
I'm new to SQL Server and let's say I have a user made a query and the
resultset is over 10,000 records.  How can I limit the user to retrieve 100
records at a time, the program will retrieve next 100 (101-200) records only

I am trying to insert records to a single Foxpro .dbf file from Visual
Basic 6.  On a Windows 2003 Server machine it works fine both through
the VB IDE and as a compiled dll.  On a XP Pro machine it works fine
through the VB IDE, but not as a compiled dll.  Both machines have

I have recently discovered the "table" datatype that can be used as an input
parameter in a stored procedure. I would like to pass a list or array of
string values from VB (using ADO) to the SQL Server stored procedure. What
VB datatype can I use to assign the values? For instance, ...

Hello !! Why "with nowait" does not work property in ADO ??? In this case
CREATE proc habibi_ac_test
as
raiserror('Some message....',10,1) with nowait

I've an application developed in VB 6.0 and DB is MS-Access 2000.
Now I would like to provide backup and restore feature in the application.
That is to say that to create a backup file of the database which can be
saved.

I have the following code that runs after a sql string to insert a picture
into a picturebox that is stored in an Access table as an OLE image.  I keep
getting "invalid picture".  I am using VB6 and Access 2000.
frmA.picLabel1.Picture = rs1("picture")

One for the gurus:
I've got a great database design. Normalized as well as I can in any event.
However, I have a form where I save payment information and the payee might
be an ad hoc individual -- that is, it may be someone who does not exist in

I got this compile error:
Procedure declaration does not match description of event or procedure
having the same name.
and the code line is:

When I had VB 6.0 there was a feature that allowed you to create an Access
DB file w/o access.  I cannot find the same feature in VB.net 2003, and I
don't have access to Access or an SQL server.  Does anybody know how to do
this?

I am working with ADODB, and am trying to change the DataSource and
DataField properties of two text boxes on the fly.  See article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;189852
I have the following code:

How do I lock a particular record that one user has opened for editing?
If I use the pessimistic type, can other users view the record (but not
edit it) and return a message telling that another person is editing the
record, or does this type lock the record such that it is ...

I am interested in finding a method to use vbscriptto create an odbc
connection to an ACCESS.mdb file.  (To replace Start/Control
Panel/ODBC/NEW...)
thanks

Who cane explain me the difference between the refresh
method of an ADODC and the requery method of the matching
AdoDC.Recordset and when it is better to use the requery  
then the refresh ?