VB Forum / Database Access / June 2004

I have a generic ODBC driver. I am using ADO from VB to update a table in my
database, see the following VB program:
   Dim rs As ADODB.Recordset
   Set conn = New ADODB.Connection

Well I have a question
How can I make a selection from table from a X database and create a table
with this result in a Y database?
Help! please!

how can I identify the client PC that is accesing StoreProcedure in SQL
2000 with VB6?

Basically I'm trying to write a program (will eventually be a web service)
that will syncronise a Microsoft Access Database (this would be on the local
Machine) with a SQL Server Database (this will be on the web).
Currently I'm trying to do this by checking each record's GUID to ...

This is not a question, but a description of a simple (solved) problem
and solution which others may be interested in.
I am writing a data processing app in VB6 using ADO.  It does everything
basically using sql statements dynamically built from the user input.

I have a server component with many classes. Each class holds a disconnected
recordset which represents 1 record. The client does changes to the server
objects (add, edit, delete, etc) and saves. On saving, the server objects
should save back the data in the database, calling a ...

This is really bugging me!
I have a table that audits useage (date, time & user etc).
Every time a user changes a record it modify the record to say what
date it was last modified. Easy so far:

I have an apllication that is already running as a client server application
with Access as the DB and the interface is in VB6, now we need to use this
app. over the intranet , I tried to make a VPN but i couldnt access the .MDB
with a full path, I although I have enabled "File And ...

I am attempting to run the package and deployment wizard.
I am getting an error 372
"Failed to load msflexgrid from msflxgrd.ocx"
The version I am using came with my vb6 app.

I hope you all can give some insite on this problem. I'm having alot of problems with the ADODC control. I have a True DBgrid displaying the order details that are filtered through the data control (Filter prooerty). The recordset contains a join between two tables.
The problem is ...

Can you populate a forms 2.0 combobox without using additem, rather by
binding it directly to an Access database? I want to use the Combobox rather
than the Datacombo for some of the other properties it posses.
Nordtorp

I have also tried this in another posting
Hello everyone
I am currently writing a VB6 application that will connect to an Access database using ADO objects. The problem is that the Access database is password protected and I would like to enter the password through code when the ...

VB6 with access db backend.
I need to provide a means for a user to change a field name. I think it
can be done using a Command object, but I can't find the sql syntax to
use in the msdn. Any assistance much appreciated.

Is there a way to check if a Table is present using ADO once the database is
successfully opened. If the Table is not present, I know I can create the
Table with no problem. Just want to trap if the Table exists.
Thanks in advance,

All,
I'm getting an error when calling a Stored Procedure from VB6 (to SQL2000)
Tested the stored proc and thats fine when run in SQL query tools.
From VB6 I'm creating a ADODB.Command (mdac 2.5) and adding parameters -