Welcome to SPN

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

Sign Up Now!

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
    >> >> >
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     

Share This Page