deleting table links (XP)

Topic

New Reply

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

Reply | Quote

Replies

I am deleting them manually.

Reply | Quote

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.

Reply | Quote

Yep – That did the job.

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

Reply | Quote

> How would you undelete a table?

Edit | Undo delete (or something similar)

Reply | Quote

Of course, Thanks.

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote