Results 1 to 4 of 4

Thread: Problems with the OpenSchema method

  1. Jan 12th, 2000, 04:30 AM #1
    Forest Dragon
    Forest Dragon is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 1999
    Posts
    253

    Post

    Hi everybody!!!

    I have a problem with the OpenSchema method. I want to display all the tables and the queries in a database with their fields. The method shows all the tables and the queries but not all the fields!!! There are tables/queries which it shows only part of the fields, and there are tables/queries which it doesn't show any fields at all!!!

    Can anybody give me an explanation why it is so and what I need to do in order to fix that?

    Thanks!!!

    Reply With Quote Reply With Quote
  2. Jan 12th, 2000, 11:48 AM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    I believe that the driver has to support the functions being called by ADO, and drivers have a varying level of compliance. What database/driver are you using?
    Reply With Quote Reply With Quote
  3. Jan 13th, 2000, 07:36 PM #3
    Forest Dragon
    Forest Dragon is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 1999
    Posts
    253

    Post

    I am trying to connect to an Access database through the Microsoft Jet OLEDB 3.51 provider.
    Reply With Quote Reply With Quote
  4. Jan 13th, 2000, 11:49 PM #4
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    Get the fields via OpenSchema(adSchemaColumns)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width