VB Forum / Database Access / September 2004

Hi. I I am new to VB6. I have read a lot of the faq about opening
accessdb´s and am confussed about how to go about it.
I have tables in Ms Access 2002 which contain data I want to use  in a VB
form maybe manipulated and save back to the access db.

I keep getting this error, and I can't seem to find the source of it.
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
2.

I have written a VB6 application that records Groups of instructions to a MS
SQL2000 DB. I call these groups Scenarios.
These instructions perform certain tasks.
This was all working perfectly until last week some time there was reports

I have a legacy application which I'm converting to used linked tables (to a
MySQL database). The Access database is Access 97, and I can't change that.
I've used Wise to create an installation program which worked perfectly on
4 different machines. I then reached one machine that ...

can somebody tell me where can i get the vb5/6 decompiler.thanks
loktakch@hotmail.com

In VB6, how can we create an ado recordset and then use it as input to
create a subsequent recordset. For example, if we create RS1 at (b) below,
we get the following error at (d) when we try to use it in the sql statement
to build RS2:  "The Microsoft jet database engine cannot ...

On my XP box I have upgraded to MDAC 2.8 and I now am experiencing database
corruption on my Access 2000 databases.  This corruption is to the point
where I have to retrieve the database from backup.
Is anyone else having the same problem?

I have a complex set of updates/inserts/deletes in one transaction, and I
want to roll back if there is an issue.  However, sometimes there may be an
error before a transaction ever takes place or after the "commit" is issued.
Is there a way to test an ADODB connection object to see ...

I want to check if all the records in a particular field ,say
[remarks] ,contain data or not.
If all records in [remarks] contain no data, then do a event ,say,
displays a message "remark field contain no data". Else if one or more

I keep getting this error, and I can't seem to find the source of it.
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
2.

I have a ms sql server 2000 database table with a timestamp column.  This
table needs to be updated via a stored procedure.  I am using vb.net 2003.
What datatype can I use to store the timestamp value in vb.net and how
should the parameter be established using the sqlclient ...

In VB6, how can we create an ado recordset and then use it as input to
create a subsequent recordset. For example, if we create RS1 at (b) below,
we get the following error at (d) when we try to use it in the sql statement
to build RS2:  "The Microsoft jet database engine cannot ...

I have an app I just changed fro using DAO to ADO and now its
10 times slower.
I run both on the same machine with the same qry.
Whats going on here?

I've got the following code :
   Dim ac As ADODB.Connection
   Dim rsCount As New ADODB.Recordset
   Set ac = .....connectionstring, etc..

Can any one please help me about  This.
which  is the optimized code(1 or 2).
1. Open and using a single recordset object and then closing it ,is a good
optimization techneic (in this case hardly two three recordset object is