Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

How to link table from code

Discussion in 'Information Technology' started by Domac, Jul 28, 2006.

Tags:
  1. Domac

    Domac
    Expand Collapse
    Guest

    Hi,

    I need to link tables from code (autoexec macro that runs function)
    depending of company department.
    All departments use same database structure but from different location.

    How to link tables from code???



    Thanx
     
  2. Loading...


  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    There is code to relink Access tables at the following URL ...

    http://www.mvps.org/access/tables/tbl0009.htm

    --
    Brendan Reynolds
    Access MVP

    "Domac" <dd.cc@cc.cc> wrote in message
    news:ePjP5q7iGHA.1260@TK2MSFTNGP05.phx.gbl...
    > Hi,
    >
    > I need to link tables from code (autoexec macro that runs function)
    > depending of company department.
    > All departments use same database structure but from different location.
    >
    > How to link tables from code???
    >
    >
    >
    > Thanx
    >
    >
    >
     
  4. Domac

    Domac
    Expand Collapse
    Guest

    Thanx a lot!

    "Domac" <dd.cc@cc.cc> wrote in message
    news:ePjP5q7iGHA.1260@TK2MSFTNGP05.phx.gbl...
    > Hi,
    >
    > I need to link tables from code (autoexec macro that runs function)
    > depending of company department.
    > All departments use same database structure but from different location.
    >
    > How to link tables from code???
    >
    >
    >
    > Thanx
    >
    >
    >
     
  5. Nuno Guerra

    Nuno Guerra
    Expand Collapse
    Guest

    Hi. I tried this sample code, but it only works to access tables.
    I have the same problem with Oracle OBDC Tables.

    How can I refresh this kind of linked tables from Oracle ODBC tables?

    thanks

    "Brendan Reynolds" wrote:

    > There is code to relink Access tables at the following URL ...
    >
    > http://www.mvps.org/access/tables/tbl0009.htm
    >
    > --
    > Brendan Reynolds
    > Access MVP
    >
    > "Domac" <dd.cc@cc.cc> wrote in message
    > news:ePjP5q7iGHA.1260@TK2MSFTNGP05.phx.gbl...
    > > Hi,
    > >
    > > I need to link tables from code (autoexec macro that runs function)
    > > depending of company department.
    > > All departments use same database structure but from different location.
    > >
    > > How to link tables from code???
    > >
    > >
    > >
    > > Thanx
    > >
    > >
    > >

    >
    >
    >
     
  6. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    It's the next one in the list, Nuno! :)

    http://www.mvps.org/access/tables/tbl0010.htm

    --
    Brendan Reynolds
    Access MVP

    "Nuno Guerra" <NunoGuerra@discussions.microsoft.com> wrote in message
    news:F331A0BD-5C43-49C9-A1B0-00F40D1900C4@microsoft.com...
    > Hi. I tried this sample code, but it only works to access tables.
    > I have the same problem with Oracle OBDC Tables.
    >
    > How can I refresh this kind of linked tables from Oracle ODBC tables?
    >
    > thanks
    >
    > "Brendan Reynolds" wrote:
    >
    >> There is code to relink Access tables at the following URL ...
    >>
    >> http://www.mvps.org/access/tables/tbl0009.htm
    >>
    >> --
    >> Brendan Reynolds
    >> Access MVP
    >>
    >> "Domac" <dd.cc@cc.cc> wrote in message
    >> news:ePjP5q7iGHA.1260@TK2MSFTNGP05.phx.gbl...
    >> > Hi,
    >> >
    >> > I need to link tables from code (autoexec macro that runs function)
    >> > depending of company department.
    >> > All departments use same database structure but from different
    >> > location.
    >> >
    >> > How to link tables from code???
    >> >
    >> >
    >> >
    >> > Thanx
    >> >
    >> >
    >> >

    >>
    >>
    >>
     
  7. Nuno Guerra

    Nuno Guerra
    Expand Collapse
    Guest

    You are right, however, i'm having some dificulties to put this code working.
    I'm not sure witch part of the code should be in a module, or directly in a
    object event.
    can you help me?

    I build the table tblReconnectODBC and I want now to test it in a click
    event button.
    How can I test it?

    "Brendan Reynolds" wrote:

    >
    > It's the next one in the list, Nuno! :)
    >
    > http://www.mvps.org/access/tables/tbl0010.htm
    >
    > --
    > Brendan Reynolds
    > Access MVP
    >
    > "Nuno Guerra" <NunoGuerra@discussions.microsoft.com> wrote in message
    > news:F331A0BD-5C43-49C9-A1B0-00F40D1900C4@microsoft.com...
    > > Hi. I tried this sample code, but it only works to access tables.
    > > I have the same problem with Oracle OBDC Tables.
    > >
    > > How can I refresh this kind of linked tables from Oracle ODBC tables?
    > >
    > > thanks
    > >
    > > "Brendan Reynolds" wrote:
    > >
    > >> There is code to relink Access tables at the following URL ...
    > >>
    > >> http://www.mvps.org/access/tables/tbl0009.htm
    > >>
    > >> --
    > >> Brendan Reynolds
    > >> Access MVP
    > >>
    > >> "Domac" <dd.cc@cc.cc> wrote in message
    > >> news:ePjP5q7iGHA.1260@TK2MSFTNGP05.phx.gbl...
    > >> > Hi,
    > >> >
    > >> > I need to link tables from code (autoexec macro that runs function)
    > >> > depending of company department.
    > >> > All departments use same database structure but from different
    > >> > location.
    > >> >
    > >> > How to link tables from code???
    > >> >
    > >> >
    > >> >
    > >> > Thanx
    > >> >
    > >> >
    > >> >
    > >>
    > >>
    > >>

    >
    >
    >
     
  8. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    I'm afraid I would not be the best person to assist you, Nuno, as I have
    never used that code. Perhaps someone who has used it might like to join in
    here?

    --
    Brendan Reynolds
    Access MVP

    "Nuno Guerra" <NunoGuerra@discussions.microsoft.com> wrote in message
    news:EDC20AEA-66FF-40F0-94B8-7C620FDF01F9@microsoft.com...
    > You are right, however, i'm having some dificulties to put this code
    > working.
    > I'm not sure witch part of the code should be in a module, or directly in
    > a
    > object event.
    > can you help me?
    >
    > I build the table tblReconnectODBC and I want now to test it in a click
    > event button.
    > How can I test it?
    >
    > "Brendan Reynolds" wrote:
    >
    >>
    >> It's the next one in the list, Nuno! :)
    >>
    >> http://www.mvps.org/access/tables/tbl0010.htm
    >>
    >> --
    >> Brendan Reynolds
    >> Access MVP
    >>
    >> "Nuno Guerra" <NunoGuerra@discussions.microsoft.com> wrote in message
    >> news:F331A0BD-5C43-49C9-A1B0-00F40D1900C4@microsoft.com...
    >> > Hi. I tried this sample code, but it only works to access tables.
    >> > I have the same problem with Oracle OBDC Tables.
    >> >
    >> > How can I refresh this kind of linked tables from Oracle ODBC tables?
    >> >
    >> > thanks
    >> >
    >> > "Brendan Reynolds" wrote:
    >> >
    >> >> There is code to relink Access tables at the following URL ...
    >> >>
    >> >> http://www.mvps.org/access/tables/tbl0009.htm
    >> >>
    >> >> --
    >> >> Brendan Reynolds
    >> >> Access MVP
    >> >>
    >> >> "Domac" <dd.cc@cc.cc> wrote in message
    >> >> news:ePjP5q7iGHA.1260@TK2MSFTNGP05.phx.gbl...
    >> >> > Hi,
    >> >> >
    >> >> > I need to link tables from code (autoexec macro that runs function)
    >> >> > depending of company department.
    >> >> > All departments use same database structure but from different
    >> >> > location.
    >> >> >
    >> >> > How to link tables from code???
    >> >> >
    >> >> >
    >> >> >
    >> >> > Thanx
    >> >> >
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page