Welcome to SPN

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

Sign Up Now!

Deleting tables not used in queries

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

  1. kayabob

    kayabob
    Expand Collapse
    Guest

    If I am deleting a table, is there any way to tell if it has been used in a
    query before I delete it?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Is Mahesh Bhatt considering deleting Meera's controversial kissing ... Breaking News Mar 4, 2005
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010
    History Cleaning Out the Augean Stables Punjab, Punjabi, Punjabiyat Aug 25, 2009

  3. Elaine

    Elaine
    Expand Collapse
    Guest

    If you right click the table and select "Object Dependencies", it will give
    you a view of all other objects (forms, queries, reports, etc) within your
    db that use that particular table.
    "kayabob" <kayabob@discussions.microsoft.com> wrote in message
    news:31261242-3478-4606-A143-8DEAE5A335E4@microsoft.com...
    > If I am deleting a table, is there any way to tell if it has been used in
    > a
    > query before I delete it?
     
  4. kayabob

    kayabob
    Expand Collapse
    Guest

    perfect, thank you.

    "Elaine" wrote:

    > If you right click the table and select "Object Dependencies", it will give
    > you a view of all other objects (forms, queries, reports, etc) within your
    > db that use that particular table.
    > "kayabob" <kayabob@discussions.microsoft.com> wrote in message
    > news:31261242-3478-4606-A143-8DEAE5A335E4@microsoft.com...
    > > If I am deleting a table, is there any way to tell if it has been used in
    > > a
    > > query before I delete it?

    >
    >
    >
     
  5. Jeff Schneider

    Jeff Schneider
    Expand Collapse
    Guest

    Is that version-specific? I'm running 2002 and do not see that as a selection.

    "Elaine" wrote:

    > If you right click the table and select "Object Dependencies", it will give
    > you a view of all other objects (forms, queries, reports, etc) within your
    > db that use that particular table.
    > "kayabob" <kayabob@discussions.microsoft.com> wrote in message
    > news:31261242-3478-4606-A143-8DEAE5A335E4@microsoft.com...
    > > If I am deleting a table, is there any way to tell if it has been used in
    > > a
    > > query before I delete it?

    >
    >
    >
     
  6. Craig Alexander Morrison

    Craig Alexander Morrison
    Expand Collapse
    Guest

    > Is that version-specific? I'm running 2002 and do not see that as a
    > selection.


    Yes only Access 2003 (currently) has it.

    The downside is that to use Object Dependencies you also have to have Track
    Name AutoCorrect enabled.

    If anyone with Access 2003 wants to use Object Dependencies and has Track
    Name AutoCorrect disabled you can make a copy of your MDB and enable
    AutoCorrect and run Object Dependencies and then use the information to work
    on your "good" MDB.

    Track Name AutoCorrect is generally considered to be buggy and can make
    Access unstable and _s l o w_, along with Lookup Fields and Subdatasheets
    which are all best avoided.

    --
    Slainte

    Craig Alexander Morrison
    Crawbridge Data (Scotland) Limited
    "Jeff Schneider" <JeffSchneider@discussions.microsoft.com> wrote in message
    news:36960B3D-9237-4A80-95F4-83CC2C79E2A1@microsoft.com...
    >
    > "Elaine" wrote:
    >
    >> If you right click the table and select "Object Dependencies", it will
    >> give
    >> you a view of all other objects (forms, queries, reports, etc) within
    >> your
    >> db that use that particular table.
    >> "kayabob" <kayabob@discussions.microsoft.com> wrote in message
    >> news:31261242-3478-4606-A143-8DEAE5A335E4@microsoft.com...
    >> > If I am deleting a table, is there any way to tell if it has been used
    >> > in
    >> > a
    >> > query before I delete it?

    >>
    >>
    >>
     

Share This Page