VB Forum / Database Access / May 2006

I'm posing to this group because I need some help with an issue I'm
encountering opening an ADO Recordset.
Posted below is the code that I am using to open the Recordset
Set rsReportData = Server.CreateObject("ADODB.RecordSet")

Can some tell me why this code isn't working?
I'm using a listview control I'm retrieving field names from a database
table and making them the column headers on the listview control. I'm then
reading the data from the selected table and I want to place the data under

I was wondering if anybody could give me some advice on why I feel that the
updates in my application feel "slow".
The application I've written downloads from an SQL Server Database, stores
this data in a DataSet, values are changed and then I use the Update command

I cant find a way to send a "mouse clic" (right or left) to an application,
like SENDKEYS for the keyboard.
Thanks for any answer

I am trying to make the color change of a datagrid if column(X) > value
while looping thru the rows returned from a query.  Can someone tell me if
this is possible.
Something like,

I have switched from Win2K SP4 to WinXP SP2 and installed VS 2005.
Since then, my VS 6.0 VB projects using the ADO data controls run VERY
slowly. Also, when compiled they will not run on pre-XP machines.
Is this a known issue? Can someone point me in the right direction?

I have a data question that google can't answer...
3043         Could not create VBA expression service.  System (DAO)
What on earth is a VBA expression service!
This occurs when executing the line

Does anyone have a solution of reading an Oracle Boolean with ADO.net?

i'm getting an error: 42s02 from my odbc command.  "it can't find the
input table or it's spelled wrong".  i've checked the spelling made
sure the tables are correct.  Has anybody seen this before?
here's the code:

This, to me, seems like something that is so often repeated in developer
circles on a daily basis that it should have it's own mini-wizard.
Unfortunately it seems to be one of those "try this and SEE if it works"
problems because nobody seems to have a succinct checklist of what ...

I update one database table usign the following code. But I need to update 2
tables both of which are joined by the Study_ID field. Study_ID is the  
AUTO_INCREMENTING primary key in the database table which I am updating.
Now, the problem is that how do I get the value of the ...

I have a difficult problem with an Oracle connection that works in some
environments and not others.
I have developed a spreadsheet which uses VBA and ADO to get data from an
Oracle database. Development and testing worked fine, Development is on a

I have a VB6 application with Access XP Database.
I developed it on XP without SP2, and I had to install MDAC 2.8 to
enable some ADO features (like search backwards in Recordsets).
Now I'm trying to run this application on Windows XP with SP2 but

In vb6 using an Access back end, how do I copy a table and the structure (no
data) into a new table?  After it's use how do I delete the new table?
Thanks
Sheldon

here is my code for a btn click event.  i want to insert fields from
one access db to another.
look for  ->>>>>>>  below.  can some help me with this syntax?  am i
opening the db's correctly?  Thanks in advanced.