Yes, you use OpenSchema.<BR><BR>1. Define a connection and recordset as usual and open the connection<BR>2. Set rs = cn.OpenSchema (adSchemaPrimaryKeys)<BR>3. Loop through the recordset and close it<BR>4. Set rs = cn.OpenSchema (adSchemaForeignKeys)<BR>5. Repeat step 3
Derek, is OpenSchema only accessible through SQL server? I keep getting an error when I try to use it with Oracle. It says 'The provider is not capable of performing the requested operation.' I am using Provider=OraOLEDB.Oracle. Thanks for any help.