VB Forum / Database Access / October 2004

I am using Access97 on Windows XP desktop and the following references:
Visual basic VBA322.DLL
Access 8.0 Object Library
Common controls 6.0

i use a recordset to read a db, this is my code, the first rec runs well and
it return me the right values... i cant open the second one, the store
pricedure return a set of rows but when i try to .movefirst it tells me that
i cant do that with a recordset not open.

I'm using ADO for a ODBC-Connection. In my Select Statement i just want to
have records which a lower (or higher) than a given Date. If I try like this
then i receive a error from the ODBC-Driver.
This is the code I'm using:

List:
I'm using VB6::DAO::Jet Engine 3.51 to update a datebase.  With db set
to a valid dao.database, I attempt:
db.execute sqlString, dbFailOnError

I have the following code which should copy a table form one access mdb to
another, however it doesn't work because the CopyFrom.mdb has a database
password and I can't figure out how to pass it or tell jet what it is.
Any ideas?

We are using VB6/ADO with Access. We have a standard header/detail
relationship between two tables (please see below) and need to perform a
seek to the detail records. However, one of the lookup fields comes from the
header. For example, we want to seek on CONTRACT_ID / PART_ID  but

When I execute this code (Below) I get Runtime Error '463' Class not
registered on local machine.
Debugger breaks on:
Set objDatabase = CreateObject("ACTOLE.DATABASE", "\\darth")

my question is described as below:
I am using the item names in the datacombo to search the information
in  access database.
The item names in the datacombo are shown by retrieving the record in

I have the codes below to do the database connection and query to SQL
Server, and add the result to a list box. I works when I add the query
result to list box.
But when I try to bind the query result to a datagrid I failed to bind the

In my VB6 App, I create a Data Environmente (DE) in Designers on Project
Window.
On that DE, I create a Connection. In Connection Properties Window, it asks
me for a server to connect with. DE activates automatically when App starts.

I use the following to set text boxes from an adodc query,
lgLiveDate.Text = "" & frmshared.datPrimaryRS.Recordset!livedate
But I realized recently that I have the same field "livedate" in two
different tables and need to distinguish one from the other. How can I do

Ref VB6 using DAO with MS Access.
Below I get an error of the following,
No current record.Error: 3021
Here is my Sql query.

I can't seem to find a working solution in the archives, so here goes:
I delete a row from a recordset (that has a primary key), but if i
ever .move to where that record was again, the program crashes with a
"Row Handle Marked for Deletion" error.

trying to open an access 2000 mdb using visual data manager .  getting the
following error
"3343 DAO workspace unrecognised database format "

Sorry if this is a supped question.
I'm working on inventory program for our small company. It will be local
database (for now) but maybe we transform it to client/server database
in future. I use Access database, ADO and VB6. My question is it better