VB Forum / Database Access / May 2004

I have two questions about executing SQL stored procedures from a vb
program.
First, how can I run other jobs while the stored procedure is executing?
I know that the user can switch to another program and run it, but when

Can i save data into 2 different tables using one recordset?
I try this but it fails on the ForeignKey that it's required on table 2 and
i doesn't have its value yet because it is a AutoIncrement field in Table1.
EXAMPLE

I'm having problems connecting to a Foxpro database via ADO in VB6. I've gotten it to work several places using the same method, but it always fails at this point with this message: 'Feature is not available.' Here is my code. Any ideas as to why this works sometimes, but not ...

was wondering if I can create an ADODB connection to an excel spreadsheet,
and interact with it using SQL statements?
if so, how do I specify the data source?
set dbconn    = server.createobject("adodb.connection")

I need to connect two office and two laptop for sharing a database
with access 2003; I'm on focus on replica statement, to manage via
vbcode.
Reading help and sites, I'm losting because I have found not

I have an application that I am developping and which I plan to use the
SHAPE construct using parent-child relationship. Most of the examples that
I've seen use some sort of datagrid to display the child records. Is it
possible to display the child records in textboxes instead and ...

I have the following SQL statement in a vb6 form:
INSERT INTO SeriesEdPriGradFem% (Country, FIPS_CODE) SELECT Country,
FIPS_CODE From [Country Translation] In 'C:\My
Documents\IFs\DATA\IFS.MDB'

One of our apps is installed at over 100 sites and in general works fine.
This app is VB6/DAO linking to Access 97 databases.
Most of these sites are XP or XP/2000 machines
At 2 sites which are all W2000 we are getting continual corruption problems,

Is it possible to update MSysObjects table from MS access database via ADO, DAO or any else
thanks

Could anyone help me with an SQL statement in VB6 please. I have a date field
in the database, after a user input a date in a text box, I want the recordset
to return all records with the month and year as the textbox.
Example: user input 5/13/2004

I'm trying to access a stored procedure on an Oracle DB server through
an ADOConnection and an ADORecordset. The procedure returns a
recordset and all fields are valid but when i try to access the
RecordCount property or the MoveNext method of the RecordSet i get an

developing my first app. using VB6
how should I go about filling my combo with customer info and be able to
save the order with respect to the customerId?
I fill my combo by:

I have an application that talk to MS Access 2003 database. I am trying to
update a field's value and get the following error and I don't understand
what it means:
           Run-time error '-2147217887 (80040e21)

I am trying to read the data from two Access tables: Cars, Owners
I am using two Data (AODBC) controls: datPrimaryRS (for Cars) and
datPrimaryRS1 (fors Owners)
For some reason, The Data for the first table is OK (it shows the right

Hi all!...I have a problem refreshing data on the Datagrid control. I
execute
sql statement directly against the underlying ADO data source (ADODC
control) and try to make changes updated