VB Forum / Database Access / December 2004

Can anyone please help with the following problem.
I have three tables and join two of them on a common field.( Table1 and
Table2)
The problem is that one of the tables might have more than one row

i'm writting a program that compares the tables and fields of two databases
in order to know if they are equal.
I allready made the code in order to see if a certain database has all the
tables that exist in the other table of the other database and i allready

Estoy tratando de crear una coneccion para leer unos datos de una base de
datos en access pero me da un error, antes lo hice pero con DSN y funcionaba
ahora cuando trato de hacerlo DSN-Less:
Run-time error

I have a database using DAO and a query. Now i'd like to show the results
in a "data control". I only have to display the query results (no editing at
all)
In my app. the user can select a database (all databases have the same

I am triying to convert a DSN access connection, to a DSN Less connection
but I am getting errors, on the DSN connection it worked but now  doesnt,
I'm getting this error:
Run-time error

I'd like to create a middle tier object for my application, an api of sorts.
this api would only expose the business objects, not the underlying database
components.  consequently, i'd like to convert a recordset's fields into a
generic collection of field objects.  is there a ...

I have a large table in a MySQL database. To add records to this table, I
usually do:
' Connect to db. Connection is cn.
Set rs = new ADODB.Recordset

I have the following scenario, please tell me if this is possible:
I have a multiuser application. I have a master-entry form for (example)
Countries. Another form lists the Countries in a DBGrid.
My problem is when User A enters a new Country thru the Master Form, then

I am using Visual Basic 6.0 SP 5. In my application if there is no
activity for say 5 min I want to automatically log off from this
application. When I say "no activity", I basically mean that the end
user is not using this application at all for 5 min, no mouse clicks no

Ok, this bugger is still giving me fits. All I want to do is insert a record
into a MySQL database via VB/ADO/ODBC (MyODBC 3.51) *without* reading the
entire table first. Now the ODBC driver is returning "SQLBindParameter not
called for every parameter) - which I gather means that ...

I need to convert a VB6 ADO Recordset to XML so that it can be serialized and
passed into a .NET Web Service.  Can anyone help me with this?
Thanks

I have a table in which I would like to delete some records that don't have a
particular character at the beginning of the field.  An sql statement in
ACCESS works properly, but when I try to execute the same delete from VB6 via
ado...

This reports an error
Private Sub cmdlogin_Click1()
    Dim cnMySql As New rdoConnection
    Dim rdoQry As New rdoQuery

I'm wondering if there are any fellow VB6 coders our there that have coded
projects using the command line BCP program from SQL Server to import data.
We have a couple production applicatoins as work that uses BCP behind the
scenes to load our DSS servers on a nightly basis.  For ...

Hello, I use a recordset and bind to a grid, when I refresh the recordset,
the cursor move back to the
first record, I added a bookmark to avoid the movement, but still,
sometimes, the bookmark cursor