VB Forum / Database Access / December 2003

I have a select statement that works both in TOAD and SQLPLUS on our
clients in under 1 second to return 28 records.  Using ADO and Oracle
ODBC Driver (8.1.7) the same statement takes over 10 seconds on the
same machine.  I have no idea where to start troubleshooting this, but

I got som edata priblem with a software in VB6 that write in a access97
Database.
The software use DAO binded controls. Sometimes (randomly) when creating
records, I find some bad values in some fields like "<èÿ~$< ". It seem to be

How can I get the access database with password in a .Execute statement?
My code is as following but get the invaild password error:
dbTemp.Execute "INSERT INTO table_a SELECT * FROM table_b IN '" &
dbHasPassword & "'"

Does anyone have an example how to write code that will do the following on
startup?
1.       Check to see if FILE DSN already in system ( IF EXSIST QUIT )
2.       If it doesn't create the new FILE DSN

I'm trying to alter a table in Access2k using ado in vb6. I need to add a
column of datatype "Number" but with a field size of "Replication ID".
The following gives me a syntax error:
cnn.execute "ALTER TABLE Table1 ADD COLUMN DefCode NUMBER(Replication ID)",

I want to use the recordset.save command to persist a recordset in XML,
and use aliases for all the field names. I want to use the
"name=<alias>" syntax in the XML file to save disk space.  Is there a
property of the ADO fields object that will allow me to do this?

I've added a chart to my project, the records from a database.
Problem
I have too many rows in the chart, I need to break the chart up.
So I have [Previous] and  [Next] buttons available

I'm developing an asp.net page using vb. As part of the database I use
an insert statement to fill all data columns with the correct data
when the user hits submit. The autonumbered primary key is
automatically generated.

vb6 with all sp's
i am trying to assign the properties of a data control with dao's at
run-time. i get an "invalid use of property" highlighting the section
surrounded in *'s below.

the setup:
vb6 with latest sp
office 2000, fully updated
access2k db

I have had a problem with Jet that is pretty much
identical to the problem stated in your knowledge base:
http://support.microsoft.com/default.aspx?kbid=245676
This article is regarding Jet 4.0 and there is a patch

I have inserted a combobox into a datagrid cell.  I am having difficulty
getting the cell to retain the combobox selection.  When I leave the cell,
it remains empty.
Here is the code, based on the Microsoft Article Q323167:

Wonder if you can help.
I'm doing a VB front-end to Access DB app and wanted to know if there was a
more versatile way to use my ADO code when updating/querying the DB.
At present each of my forms have the following code in them to do certain

I have a problem on a username password login form.  I use:
txtPassword.Text = StrConv(txtPassword.Text, vbProperCase) to validate the
proper case when someone enters their name and password.  It work when you
use the button to continue, but if you hit enter on your keyboard the ...

Hi group,
I have some troubels with my VB .NET. I've got an Oracle table and in that
table I store
codeID      (Primary Key)