VB Forum / Database Access / November 2004

I want to use GetRows() instead of RecordCount, but i have some problem with
array in VBscript (ASP).
This is what i want to change with GetRows():
<%

The query "Delete * from BaseRecord WHERE Campaign Like 'C1A*'" works fine
in Access, but when the same query is run via an ADO Connection object to
the same Access MDB file, it doesn't delete anything.
The query "Delete * from BaseRecord WHERE Campaign = 'C1A-PQ1'" works from

I've read MSDN documentation on ADO 2.8 API reference, ADO Recordset. I'm trying
the following code under VB6:
Dim rs As New ADODB.Recordset
...

I'm running a VB6 app. and in this app, I run another VB6 app using the
SHELL command (both are devloped in VB6 by myself)
I want, from the first app, to write a text in the second app textbox and/or
control that second app from the first one,

I'm performing a query on Active Directory using ADO, passing a command text
of the mixed SQL and LDAP dialects but I seem to be having trouble witht
large recordsets. We're in the porgress of migrating an online app from
Win2000 to Win2003 and need to carry-out performance ...

COULD SOMEONE TELL ME, HOW I CAN MAKE A FORM MOST LARGE THAN A SCREEN
??HAVING A SLIDE BAR.
I HAVE MANY DATA IN THE WINDOW, BUT ARE VERY JAM THE CONTROLS IN THE SCREEN.
CAN YOU HELPME??

I understand that the basic principles to create a TCP/IP backup program for
a remote MySQL DB are:
a) Query/retrieve the schema.
b) Query/retrieve each table and create inserts for each row of data.

Any one know the value of the constant
adCmdStoredProcedure
Thank you

Hey is there a way to set up my access database to show news or a pictures
set by what day it is?  If so how?

When accessing a recordset using ado syntax, am I correct that I must be
calling a defined view or SP?
I have the following line:
   rs.Open "strSQLM", cnn, adOpenDynamic, adLockOptimistic

I'm trying to show the result of one query in a form, but VB show me
the error Type mismatch, but I really don't understand why it
happens...
Private Sub Form_load ()

Ado was not a problem to me... until today....
I don't know why i can't save or modify my recordset but i can delete a
record...
I 'm going to post a part of my code... may someone help me????

I wrote a a code to avoid repeating the same code after getting the
result of a query, but VB said there's an error: ByRef argument type
mismatch
The funny thing is that code works in another application that I wrote

Ado was not a problem to me,even if i'm a novice... until today....
I don't know why i can't save or modify my recordset but i can delete a
record...
I 'm going to post a part of my code... may someone help me????

I understand that the basic principles to create a TCP/IP backup program for
a remote MySQL DB are:
a) Query/retrieve the schema.
b) Query/retrieve each table and create inserts for each row of data.