Refresh Table Links With VBA - ADO DAO RDO RDS

This is a discussion on Refresh Table Links With VBA - ADO DAO RDO RDS ; Hello, I am simply looking for an example of how to automatically refresh tables that are linked to SQL Server. Everything I have found so far deals with Access to Access linkage. If any of you experts could provide a ...

+ Reply to Thread
Results 1 to 6 of 6

Refresh Table Links With VBA

  1. Default Refresh Table Links With VBA

    Hello,

    I am simply looking for an example of how to automatically refresh tables
    that are linked to SQL Server. Everything I have found so far deals with
    Access to Access linkage. If any of you experts could provide a sample, it
    would be greatly appreciated.

    Thanks!


  2. Default RE: Refresh Table Links With VBA

    For ODBC tables take a look at http://www.mvps.org/access/tables/tbl0010.htm
    --
    Hope this helps,

    Daniel Pineault
    http://www.cardaconsultants.com/
    For Access Tips and Examples: http://www.devhut.com/index.php
    Please rate this post using the vote buttons if it was helpful.



    "Jordan" wrote:

    > Hello,
    >
    > I am simply looking for an example of how to automatically refresh tables
    > that are linked to SQL Server. Everything I have found so far deals with
    > Access to Access linkage. If any of you experts could provide a sample, it
    > would be greatly appreciated.
    >
    > Thanks!
    >


  3. Default Re: Refresh Table Links With VBA

    I much prefer going DSN-less. See
    http://www.accessmvp.com/DJSteele/DSNLessLinks.html

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Daniel Pineault" <DanielPineault@discussions.microsoft.com> wrote in
    message news:813CB73E-B047-42C5-894D-9CDB4F71B709@microsoft.com...
    > For ODBC tables take a look at
    > http://www.mvps.org/access/tables/tbl0010.htm
    > --
    > Hope this helps,
    >
    > Daniel Pineault
    > http://www.cardaconsultants.com/
    > For Access Tips and Examples: http://www.devhut.com/index.php
    > Please rate this post using the vote buttons if it was helpful.
    >
    >
    >
    > "Jordan" wrote:
    >
    >> Hello,
    >>
    >> I am simply looking for an example of how to automatically refresh tables
    >> that are linked to SQL Server. Everything I have found so far deals with
    >> Access to Access linkage. If any of you experts could provide a sample,
    >> it
    >> would be greatly appreciated.
    >>
    >> Thanks!
    >>




  4. Default Re: Refresh Table Links With VBA

    Thank you for that Douglas! I wasn't even aware you could do this.
    --
    Hope this helps,

    Daniel Pineault
    http://www.cardaconsultants.com/
    For Access Tips and Examples: http://www.devhut.com/index.php
    Please rate this post using the vote buttons if it was helpful.



    "Douglas J. Steele" wrote:

    > I much prefer going DSN-less. See
    > http://www.accessmvp.com/DJSteele/DSNLessLinks.html
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Daniel Pineault" <DanielPineault@discussions.microsoft.com> wrote in
    > message news:813CB73E-B047-42C5-894D-9CDB4F71B709@microsoft.com...
    > > For ODBC tables take a look at
    > > http://www.mvps.org/access/tables/tbl0010.htm
    > > --
    > > Hope this helps,
    > >
    > > Daniel Pineault
    > > http://www.cardaconsultants.com/
    > > For Access Tips and Examples: http://www.devhut.com/index.php
    > > Please rate this post using the vote buttons if it was helpful.
    > >
    > >
    > >
    > > "Jordan" wrote:
    > >
    > >> Hello,
    > >>
    > >> I am simply looking for an example of how to automatically refresh tables
    > >> that are linked to SQL Server. Everything I have found so far deals with
    > >> Access to Access linkage. If any of you experts could provide a sample,
    > >> it
    > >> would be greatly appreciated.
    > >>
    > >> Thanks!
    > >>

    >
    >
    >


  5. Default Re: Refresh Table Links With VBA

    Hello and thank you both for your quick replies. Something I failed to
    mention in the post is that I have linked tables to different servers that
    need the refreshing. Is it possible to update the links to both servers at
    the same time with either of the examples? Thanks again for the help.

    "Daniel Pineault" wrote:

    > Thank you for that Douglas! I wasn't even aware you could do this.
    > --
    > Hope this helps,
    >
    > Daniel Pineault
    > http://www.cardaconsultants.com/
    > For Access Tips and Examples: http://www.devhut.com/index.php
    > Please rate this post using the vote buttons if it was helpful.
    >
    >
    >
    > "Douglas J. Steele" wrote:
    >
    > > I much prefer going DSN-less. See
    > > http://www.accessmvp.com/DJSteele/DSNLessLinks.html
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Daniel Pineault" <DanielPineault@discussions.microsoft.com> wrote in
    > > message news:813CB73E-B047-42C5-894D-9CDB4F71B709@microsoft.com...
    > > > For ODBC tables take a look at
    > > > http://www.mvps.org/access/tables/tbl0010.htm
    > > > --
    > > > Hope this helps,
    > > >
    > > > Daniel Pineault
    > > > http://www.cardaconsultants.com/
    > > > For Access Tips and Examples: http://www.devhut.com/index.php
    > > > Please rate this post using the vote buttons if it was helpful.
    > > >
    > > >
    > > >
    > > > "Jordan" wrote:
    > > >
    > > >> Hello,
    > > >>
    > > >> I am simply looking for an example of how to automatically refresh tables
    > > >> that are linked to SQL Server. Everything I have found so far deals with
    > > >> Access to Access linkage. If any of you experts could provide a sample,
    > > >> it
    > > >> would be greatly appreciated.
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > >
    > >


  6. Default Re: Refresh Table Links With VBA

    It's possible, but not without changes to either example.

    In a nutshell, the value to which you'll be setting the Connect property
    will depend on which table it is. You'll have to add logic to determine what
    the correct value is for each table.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Jordan C. Schroeder" <JordanCSchroeder@discussions.microsoft.com> wrote in
    message news:380B4990-8722-4989-BDDC-061B55428F32@microsoft.com...
    > Hello and thank you both for your quick replies. Something I failed to
    > mention in the post is that I have linked tables to different servers that
    > need the refreshing. Is it possible to update the links to both servers
    > at
    > the same time with either of the examples? Thanks again for the help.
    >
    > "Daniel Pineault" wrote:
    >
    >> Thank you for that Douglas! I wasn't even aware you could do this.
    >> --
    >> Hope this helps,
    >>
    >> Daniel Pineault
    >> http://www.cardaconsultants.com/
    >> For Access Tips and Examples: http://www.devhut.com/index.php
    >> Please rate this post using the vote buttons if it was helpful.
    >>
    >>
    >>
    >> "Douglas J. Steele" wrote:
    >>
    >> > I much prefer going DSN-less. See
    >> > http://www.accessmvp.com/DJSteele/DSNLessLinks.html
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "Daniel Pineault" <DanielPineault@discussions.microsoft.com> wrote in
    >> > message news:813CB73E-B047-42C5-894D-9CDB4F71B709@microsoft.com...
    >> > > For ODBC tables take a look at
    >> > > http://www.mvps.org/access/tables/tbl0010.htm
    >> > > --
    >> > > Hope this helps,
    >> > >
    >> > > Daniel Pineault
    >> > > http://www.cardaconsultants.com/
    >> > > For Access Tips and Examples: http://www.devhut.com/index.php
    >> > > Please rate this post using the vote buttons if it was helpful.
    >> > >
    >> > >
    >> > >
    >> > > "Jordan" wrote:
    >> > >
    >> > >> Hello,
    >> > >>
    >> > >> I am simply looking for an example of how to automatically refresh
    >> > >> tables
    >> > >> that are linked to SQL Server. Everything I have found so far deals
    >> > >> with
    >> > >> Access to Access linkage. If any of you experts could provide a
    >> > >> sample,
    >> > >> it
    >> > >> would be greatly appreciated.
    >> > >>
    >> > >> Thanks!
    >> > >>
    >> >
    >> >
    >> >




+ Reply to Thread