VB Forum / Database Access / July 2004

I am using VB6 and Access 97 via ADO.  My question is this:
I have a variable (txtFieldName) that contains the name of a field in
an already created record set.  I would like to access that field in
the record set using the variable name.  Is this possible with Visual

I have a program as below. Since the data is huge, I found that the performance is too slow especially the following command. Is there any other options to make it faster?
"rstMDB.Find "UID = " & rstPOS!UID, 0, adSearchForward, adBookmarkFirst"

I am beginning a new VB6 project that will rely on a database I am building
in Access.
The users will not have MS Access installed on their system. I have a
Reference in my project to ADO 2.7. Is that all I need to add so that people

Can anyone direct me to sample code on how to connect to a remote
MYSQL webserver with Visual Basic 6?

Any knowledgeable opinions would be greatly appreciated.
I query three tables until a SSN value is found.
If not found, I close the recordset and reopen the same rs
object with a new Sql string.

G'Day Folks,
I have a script that I want to use with SQL Server. What
I want the script to do, is run a query in sql for the
current date time as star date time and current date

is there a replace or some other function that i can use to chnage some data
in proces of retriving data from sql server
we have a sql server with SCALA program form accounting.. and i'm retriving
financial cards of subscribers thru ado i vb6 aplication for displaying ...

At the begining of my VB program., I can link a table to a data control such
as:
   forMAIN.vbdCLIENT.DatabaseName = DATAPATH & FILENAME
   forMAIN.vbdCLIENT.RecordSource = jCLIENT.Name

I have a problem displaying images on a form. The situation is a follows:
There is a folder containing cd-covers. I want to display them on a form.
Each time I open the form the folder must be scanned to check which
cd-labels are present.

Is there a good way to deploy MSDE2000 from VB6?
I want to handle installation status and error messages etc...

How I can get via SQL the USERS and GROUPS and then membership (user is a
meber from a group) for MS Access databases?
Best regards
Steffen

how can I get a macro to run when I open a named excel file

Hallo together!
I have the problem, that i want to change the password of some
SQL Server logins. Therefore a few code lines are necessary,
listed below. With SetPassword it is possible to give a new

I have code like the following:
cnn As New ADODB.Connection
On Error GoTo MY_ERROR_HANDLER
    cnn.Open _

Hello, there.
this is the first time I am trying to use this feature: I am creating a
recordset like this (in VBScript - anyway, is VBScript considered offtopic
here?):