VB Forum / Database Access / May 2005

Hi Group --
I have a question that is probably an easy one for someone
who has run across this before.
I'm opening two Access databases using jet4 and setting the

I've set up a connection and recordset to access an Excel 2000 spreadsheet
from VB6 (pretty much as described in this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;278973 ).
The recordset is returned OK, and I can read through the rows of data, but

In Northwind, there is an employees table which store photos.  It seems the
pictures are linked to the picture files because there is a photopath field
containing the path.  When I try to display the photos on the VB form, it
give me a error saying "unable to bind to field...".  ...

I want to update a db from textboxes, so I created an ado recordset
programatically. I open the recordset as adOpenKeySet and adLockOptimistic.
When I looked at the recordset trhough the Watch window it says:
adOpenStatic, instead of adOpenKeySet. The CursorLocation is set to

I'm in no way a SQL expert and I usually access my database with regular DAO
commands. However in this particular case I need an SQL query with inner and
outer joins combined.
Here's the last working version of my query:

Hy!I need help!I construct VB aplication and instaled on my computer.Every
time when I try to load aplication my computer starts instaling microsoft
office premium.I have all nessery files.I know that because on other
computer my aplication works fine.PLEASE HELP! ...

I have an ado data control that uses a select statement to get all the
customer names from a database.  Then I use the datacombo control to
display the customer names.
That all works fine.

Mostly I'd choose MySQL as backend when the server is
not Windows-based, and choose SQLite if the concurrent
users is equal or less than 3 (by SMB peer-to-peer).
As I have no experience on MS SQL, Oracle, or any others,

want to find all records that are NOT in another table.  All the joins
I know return where a record exists.
Ex. I have two tables.  Each have an Item field. I want an sql
statement that will tell me what records in table A are NOT in table B

I created a function whose only job is to open a recordset, passing various
parameters to it that it might need to know. The idea was to then pass that
recordset back to whatever code needed it. I'm running into issues with open
connections. I can't close the connection because I ...

Can anyone tell me if the native version of ADO that ships with Win  Server
2003 supports Oracle's XML data type?  I want to use an XML data type in my
data type but I don't know where to begin.  Do I need a certain Oracle
driver (or should I say provider)?

I've noticed that if I call DataReport1.Show that after I regain control
after that call that the MDB file that the report used still has a lock on
it, as is evident by the LDB file. I've even tried calling "Unload
DataReport1" and still the same thing. Only when my application ...

I all,
I would like this process to execute a update procedure with ADO and
XML file.
1- Select two fields (primary key and a other) of one table from my

I got no choice for a Local Database File in VB Express in the Data Source
Configuration Wizard.
I got VFP OLE DB driver installed...
?

I created a DataEnvironment and a corresponding DataReport. The
DataEnvironment has a commaind (main table) and two other child-commands
that exposes related data other tables. The concept is identical to what the
NorthWind database uses with its "Orders" and "Order Details". I set ...