Results 1 to 8 of 8
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: deleting tabke links (XP)

    How are you deleting the table links? Manually, or using code? If the latter, what code are you using?

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: deleting tabke links (XP)

    I am deleting them manually.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: deleting tabke links (XP)

    When you delete a table manually, it is not really removed from the database immediately, because you have to be able to undo the deletion. It is merely flagged as ready for deletion and made invisible from the interface. It is still present in the TableDefs collection (DAO operates at a lower level than the Access interface). You'll have to do something that clears the undo buffer, such as closing and reopening the database, or compacting it, to get rid of the table. Or you can delete it using DAO - since this bypasses the Access interface, there is no undo and the table is really deleted.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    deleting table links (XP)

    Yesterday Hans provided me with a relinking procedure. It works fine but when I delete a table link in my frontend database the relinking procedure still finds it. Why isn't the table removed completely from the tabledefs? any ideas on how to delete it completely?

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: deleting tabke links (XP)

    Yep - That did the job.

    This then poses the question. How would you undelete a table?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: deleting tabke links (XP)

    > How would you undelete a table?

    Edit | Undo delete (or something similar)

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: deleting tabke links (XP)

    Of course, Thanks.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: deleting tabke links (XP)

    As noted, this will only work as long as you haven't closed or compacted the database.
    And if you have performed other undoable actions since deleting the table, you'll have to undo those first.

Posting Permissions

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