Fixing table links with ADO

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Randy Harris
    #1

    Fixing table links with ADO

    I've seen several very nice routines on various web sites to fix table
    links when a file is moved. So far all the ones I've found have used
    DAO. Anyone know of a sample of such a routine that uses ADO?

    Thanks,
    Randy
    Tags: None
    • Terry Kreft
      #2
      Re: Fixing table links with ADO

      What is the point, table links are ODBC connections anyway.

      --

      Terry Kreft


      "Randy Harris" <randy@no.spam. netwrote in message
      news:1qg2k2d0u6 1oaa0lg2els8b3n bdj78l6hp@4ax.c om...
      I've seen several very nice routines on various web sites to fix table
      links when a file is moved. So far all the ones I've found have used
      DAO. Anyone know of a sample of such a routine that uses ADO?
      >
      Thanks,
      Randy

        Comment

        • David W. Fenton
          #3
          Re: Fixing table links with ADO

          "Terry Kreft" <terry.kreft@mp s.co.ukwrote in
          news:A8mdnYQv9L _OSNjYRVnyvw@ec lipse.net.uk:
          "Randy Harris" <randy@no.spam. netwrote in message
          news:1qg2k2d0u6 1oaa0lg2els8b3n bdj78l6hp@4ax.c om...
          >I've seen several very nice routines on various web sites to fix
          >table links when a file is moved. So far all the ones I've found
          >have used DAO. Anyone know of a sample of such a routine that
          >uses ADO?
          >
          What is the point, table links are ODBC connections anyway.
          Er, only if they are links to an ODBC data source. If they are links
          to a Jet MDB, they aren't ODBC at all, because Access can't connect
          to Jet via ODBC. The connect strings are similar, yes, but ODBC is
          *not* involved between Access and Jet.

          --
          David W. Fenton http://www.dfenton.com/
          usenet at dfenton dot com http://www.dfenton.com/DFA/

            Comment

            • David W. Fenton
              #4
              Re: Fixing table links with ADO

              Randy Harris <randy@no.spam. netwrote in
              news:1qg2k2d0u6 1oaa0lg2els8b3n bdj78l6hp@4ax.c om:
              I've seen several very nice routines on various web sites to fix
              table links when a file is moved. So far all the ones I've found
              have used DAO. Anyone know of a sample of such a routine that
              uses ADO?
              This is like asking if your German-to-English dictionary is
              available in translation into English.

              The question makes no sense. If you're working with Jet data, you
              shouldn't be using ADO.

              --
              David W. Fenton http://www.dfenton.com/
              usenet at dfenton dot com http://www.dfenton.com/DFA/

                Comment

                • Randy Harris
                  #5
                  Re: Fixing table links with ADO

                  On Mon, 30 Oct 2006 15:05:57 -0600, "David W. Fenton"
                  <XXXusenet@dfen ton.com.invalid wrote:
                  >Randy Harris <randy@no.spam. netwrote in
                  >news:1qg2k2d0u 61oaa0lg2els8b3 nbdj78l6hp@4ax. com:
                  >
                  >I've seen several very nice routines on various web sites to fix
                  >table links when a file is moved. So far all the ones I've found
                  >have used DAO. Anyone know of a sample of such a routine that
                  >uses ADO?
                  >
                  >This is like asking if your German-to-English dictionary is
                  >available in translation into English.
                  >
                  >The question makes no sense. If you're working with Jet data, you
                  >shouldn't be using ADO.
                  I guess I have no sense. I'm just not smart enough to realize that I
                  shouldn't be using ADO.

                    Comment

                    • Lyle Fairfield
                      #6
                      Re: Fixing table links with ADO

                      Randy Harris wrote:
                      On Mon, 30 Oct 2006 15:05:57 -0600, "David W. Fenton"
                      <XXXusenet@dfen ton.com.invalid wrote:
                      The question makes no sense. If you're working with Jet data, you
                      shouldn't be using ADO.
                      I guess I have no sense. I'm just not smart enough to realize that I
                      shouldn't be using ADO.
                      Me too! David has told us often enough. Why can't we learn?

                      Lyle Fairfield

                      from
                      http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacroadmap.asp


                      Current MDAC Components
                      These components are supported in the current release. Use these
                      components when you develop new applications or upgrade existing
                      applications.

                      ADO: ActiveX Data Objects (ADO) provides a high-level programming model
                      that will continue to be enhanced. Although a little less performant
                      than coding to OLE DB or ODBC directly, ADO is straightforward to learn
                      and use, and can be used from script languages such as Microsoft Visual
                      Basic® Scripting Edition (VBScript) or Microsoft JScript®.

                      --------------

                      Obsolete Data Access Technologies
                      Obsolete technologies are technologies that have not been enhanced or
                      updated in several product releases and that will be excluded from
                      future product releases. Do not use these technologies when you write
                      new applications. When you modify existing applications that are
                      written using these technologies, consider migrating those applications
                      to ADO.NET.
                      The following components are considered obsolete:
                      ....
                      Data Access Objects (DAO): DAO provides access to JET (Access)
                      databases. This API can be used from Microsoft Visual Basic®,
                      Microsoft Visual C++®, and scripting languages. It was included with
                      Microsoft Office 2000 and Office XP. DAO 3.6 is the final version of
                      this technology. It will not be available on the 64-bit Windows
                      operating system.
                      .....

                        Comment

                        Previous template Next
                        Working...