Get primary keys on windows NT

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: sukumar (sukumar_at_discussions.microsoft.com)
Date: 06/22/04

  • Next message: sukumar: "Get primary keys on Windows NT" 
    Date: Tue, 22 Jun 2004 01:04:01 -0700

    hi,
     I find problems in retrieving primary keys of an mdb file on WinNT using ADO. I use Connection.OpenSchema(adSchemaPrimaryKeys). But on Win2000 there is no problem. Why is it so? Is there any workarounds?

    Thanks in advance,
    smn.

  • Next message: sukumar: "Get primary keys on Windows NT"

    Relevant Pages

    • Get primary keys on windows NT
      ... I find problems in retrieving primary keys of an mdb file on WinNT using ADO. ...
      (microsoft.public.data.ado)
    • Re: How to enforce subtypes/supertypes in Access 2000?
      ... So I focussed on the dirty event. ... If I code everything using DAO now, will I need to re-code everything ... into ADO later, or does VB.Net not care which one you reference? ... Will they be packaged with my .mdb file if I ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Unable to open Acces files on a server
      ... Access file through ADO, which does not need either to start ACCESS ... manipulate data n that *MDB file (Assume you do it in a stand-alone VB app ... > Dim MyConn As ADODB.Connection ... > Set MyConn = New ADODB.Connection ...
      (microsoft.public.vb.general.discussion)
    • Re: Performance problem
      ... I was doing an unnecessary SQLAllocHandle and SQLFree inside a tight loop which when removed got things going again. ... It's certainly might, the one big advantage of using a mdb file is that jet 4.0 ships with windows, and windows vista right out of the box. ... The beauty of this approach would be that you would be able to run your code on Windows XP, or vista without installing additional software libraries (you'll likely have to include a ado reference in the project that you create, but other than that you would not be beholden to using MS access for your application. ...
      (microsoft.public.access.gettingstarted)
    • Re: Any REAL reason to use ADO vs. DAO?
      ... Not only should the tests be limited to a .mdb file, ... specify the Connection String (provider, file location, etc) as well as ... Cursor Types, Locations, DAO and ADO versions. ...
      (microsoft.public.vb.general.discussion)