Welcome to SPN

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

Sign Up Now!

source for the linked table

Discussion in 'Information Technology' started by Kanan, Nov 8, 2005.

  1. Kanan

    Kanan
    Expand Collapse
    Guest

    I inherited an Access 97 database from one of my co-worker who is no longer
    with the company. The issue is there is a linked table to an EXCEL
    spreadsheet in this database and I can't figure out where the EXCEL
    spreadsheet is located. In other words, I would like to know the source for
    te lined table. Can somebody help me on this?

    Kanan
     
  2. Loading...

    Similar Threads Forum Date
    Gurus Significance of Contemporary Persian Sources Relating to Guru Gobind Singh History of Sikhism Dec 21, 2013
    Gurus The Original Sources of Sikh History History of Sikhism Jan 2, 2013
    Gurbani is Source of the Five Symbols of the Khalsa - Dr. Nikky Guninder Singh Sikh Sikhi Sikhism Jul 21, 2011
    21 Sources of Protein for Vegetarians Health & Nutrition Oct 25, 2010
    Gurus Did An Italian Surgeon Attend Guru Gobind Singh In 1708? (from Portuguese Sources) History of Sikhism Oct 3, 2010

  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    Open the table in design view and select Properties from the View menu.

    Alternatively, in the VBA Immediate window type ...

    ? CurrentDb.TableDefs("YourTableNameHere").Connect

    --
    Brendan Reynolds


    "Kanan" <Kanan@discussions.microsoft.com> wrote in message
    news:036D961C-C536-4822-9189-A88F635551B4@microsoft.com...
    >I inherited an Access 97 database from one of my co-worker who is no longer
    > with the company. The issue is there is a linked table to an EXCEL
    > spreadsheet in this database and I can't figure out where the EXCEL
    > spreadsheet is located. In other words, I would like to know the source
    > for
    > te lined table. Can somebody help me on this?
    >
    > Kanan
     

Share This Page