VB Forum / Database Access / September 2006

I have the following code
      If Not ADODCProperties2.Recordset.EOF Then
           If fnSearchSwitch2 Then
                ADODCProperties2.Recordset.Find "Address1 LIKE '" &

Ms Sqlserver is running in one of the pcs in lan  running XP
Is it possible to enumerate the Sqlserver path  "with out installing
SqlClient." from lan?
SQLDMO needs  SqlClient

My developer environment:
Informix Client 2.90 / Server 10.0
ADO 2.8
VB6

I ahve a while loop where I need to check if the name of the code
already exist in the table. I have a variable to get the name of the
code from the table, but it won't go to the next row.. so I put another
loop so it will go throught the whole table to see if the new code exist

Is there a difference to the final size of a database if the data is saved
in one of two ways, for example:-
           Field 1    Field2      Field 3 field 4         etc  ....
Row1    Data1    Data2    Data3    Data4            etc . . .

I need to copy the contents of one column to another in my database.
Iknow that I need to match the information from column A in table 1 to
column A in table 2, then copy column X from table 1 to column X in
table 2, but I am not sure how to do this.  (Obviously I am not a db

Hi, I am pretty new in vb and having problems with arrays...
I am trying to use dis function.
in my ohter method i have an array called ATest. Then I am using it to
put k - 1 data.in my other function i want to use it. Like

I'm fairly new to creating databases, so I apologize is the answer to
this is obvious.
Basically I have about 1000 pre-made files which I have VBA chug
through and populate a row with header information for each file. The

If I do not care about CursorType of the Recordset I use this approach to
populate it:
Dim cnn as ADODB.Connection
Dim cnd as ADODB.Command