Post by Jordi Martine » Sat, 15 Sep 2001 20:55:15

Hi all

    Someone tell me that ADOX could be erased from ADO. Is this true?




Post by Jon Burch » Sat, 29 Sep 2001 07:45:24

Hi Jordi,

I'm not exactly sure what you mean by this question, but ADOX is
distributed with MDAC as well as ADO.  There is no way to install only ADO
without ADOX.  For more information, I suggest you check out  Good luck!

Jon Burchel
Microsoft Corp.

Hello, Im the humble disclaimer.? Nobody really likes me.? Im used to
being ignored and maligned I still get the job done.? If you cared enough
to read me, youd learn that this posting is provided AS IS with no
warranties, and confers no rights. You assume all risk for your use. ? 2001
Microsoft Corporation. All rights reserved.


1. ADOX.Indexes/ADOX.Key/Foreign Keys

I am trying to generate a VB program which analyses an existing MDB and writes the VB
source code necessary for creating the MDB from scratch using ADOX. I have hit the
following problem when looping through the Indexes collection of the Table object:

When you create a relationship (i.e. under Access) between 2 tables, an Index is created ,
but the index is *not* visible to Access.  ADOX *does* see this index but the ADOX.Index
object does not have a property for distinguishing between an Index which was created in
order to establish a relationship between tables.

Example:  I visually create the following relationship under Access:

Customers.ID   ----- 1:n -------> Orders.Cust_ID   (this will create the invisible index!)

Under VB, when I loop through the oCat.Tables("Orders").Indexes collection, I will find an
index called "CustomersOrders", kindly supplied by Access behind the scenes.

Using the Indexes collection I need a way of sifting out indices which were the result of
creating a relationship between tables. How? The Index object does not have a RelatedTable


2. Pdox 5 and NT4 - how?

3. What is this ADOX? Can you create a Table using ADO or must you use ADOX?

4. From DB2 to Paradox

5. Using ADOX

6. Newbie Q: logical backup

7. ADOX and Stored Procedure Problem

8. Newbie RI/Trigger Question

9. Create local SSCE database without ADOX

10. Create adTinyInt column with ADOX in SQLServer causes error

11. Create SQLServer DB from ADOX-VB6

12. ADOX Troubles

13. ADOX - Class not registered