Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Posts
    4

    Unanswered: eliminating dependency

    Good day,

    I've a database with a two tables dependent one on another.
    I deleted one of them and I need to remove or eliminate the dependency
    any body could tel me how on earth to do that.

  2. #2
    Join Date
    May 2010
    Posts
    601
    Basically you will have to go through ever object in the database and remove ever reference to the delete table.

    There are some add-ins that will help you search your database. A free one is V Tools.

    I find it best to documented the database before you delete the table to find all the dependencies.

    What version of Access are you using?
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Nov 2010
    Posts
    4
    Quote Originally Posted by HiTechCoach View Post
    Basically you will have to go through ever object in the database and remove ever reference to the delete table.

    There are some add-ins that will help you search your database. A free one is V Tools.

    I find it best to documented the database before you delete the table to find all the dependencies.

    What version of Access are you using?
    Thanks a lot HiTechCoach,

    It worked perfectly and solved my problem. thanks again.

  4. #4
    Join Date
    May 2010
    Posts
    601
    You're welcome.

    Glad we could assist.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •