VB Forum / Database Access / May 2005

I have a series of recordsets that I will be creating and populating.  My
question is, how do I create queries to 'join' the recordsets together...
I.e., here is my code thus far is below... at the end, I'd like to do
something funky, like a Join between the rstConnectors ...

I'm using VB6, ADO, and Oracle 8.1.6, ComponentOne TrueDBGrid7 and I'm
having a problem updating from a grid source...
I can connect to the database, and run a SQL statement on a table i.e.:
select FIELD1 from TABLE1 where COND1 = 'T'

I am trying to execute an SQL statement but get an object closed error.
It's a valid SQL and works fine in Query Analyzer.
I found some discussion about this issue but couldn't find any conclusions.
Any help is appreciated,

I am connecting to Access database using DAO. How can I create a new user
account in MDB file? I was trying to use some sample code with CreateUser()
method, but no error was reported and no user added. Can anyone recommend me
a good article on multiuser issues using VB6 and MS ...

I need to create an access database and give it a vb front. Any suggestion
on how to do that? Or where to go to find out how to do that?
Note: I don't have anyway of buying books nor do I have time to go look for
them at the library.

Is there a way to run a 'sql query' or get a subset of rows from a
disconnected resultset? Can we do this with ADOX? I have a disconnected
resultset containing all the rows in table X. Now I want to get rows
from this resultset 'where ID = 4'. Can this be done without connecting

I decided to upsize my access 2000 database to MSDE today. I'm
unfamiliar with MSDE and have a few questions:
1. How do I connect to my new database file? ('test.adp') without using
ODBC?

Hi, I'm developing an app on vb 6 and the db is sql server 2000. I've been
reading about connection pooling and how it is recommended to use it. It is
turned on by default, so as long as you follow the coding standars for ado
you should be fine, but it appears to me that ...

I have a relational database.
I retrieve a large-ish amount of data (~50,000 records) using a hierarchical
recordset (parent RS with chapter daughter RS which has its own chapter
daughter RS).

I have created an application that queries a DB and the results are put
out to a simple text file.  When I use Crystal Reports 10 to use that
text file (through DAO) for the report it takes about 1.5 min to
display the report.  In a summary report that uses about three of these

Please help.
I'm using a JetEngine.CompactDatabase call to convert an Access '97 db
and, using ADO/Jet4.Oledb, Is there any way to get back an Access 2003
format database?

I know that it is possible to create an ADODB.RECORDSET without an
underlying datasource.
What I'd like to do would be to create a recordset, populate it and then add
ALL the rows to an existing SQL table.

What's the best method to use in a VB CGI access a MySQL DB for a high
volume web site?
A little history:
A couple of years ago I wrote a VB CGI that retrieves data (a product

I'm trying to convert to an Access 2003 database using the 2.1
replication engine. Is it even possible? What is the oledb engine-type?
I've seen reference to the number 5 but that seems to be for Access
2000.

Is it possible to run query against an ado recordset.to create another
recordset?  Here's what I'm trying to do:
I created a recordset called rsCPSH.  I want to run a query against that
recordset to retrieve only those records where Invoice = OrderNumber.